DBCC IndexDefrag
Being day 16 of the DBCC Command month at SteveStedman.com, today’s featured DBCC Command is DBCC INDEXDEFRAG. Description: DBCC INDEXDEFRAG was used for to defragment indexes on SQL Server 2000, the same thing can be done with Alter Index on newer versions of SQL Server.. DBCC INDEXDEFRAG Syntax: For more info on index defragmentation, check out the Database Health Reports …