Friday, March 9, 2012

index fragmentation

Hi,
I want to defrag all the indexes in a table. How do I use after DBCC
INDEXDEFRAG?
thanks,
There is sample code for that in Books Online. Check under DBCC SHOWCONTIG.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"aoxpsql" <anonymous@.discussion.com> wrote in message news:ucfQLjSeEHA.1652@.TK2MSFTNGP09.phx.gbl...
> Hi,
> I want to defrag all the indexes in a table. How do I use after DBCC
> INDEXDEFRAG?
> thanks,
>

No comments:

Post a Comment