INDEX DEFRAG on SQL SERVER 2005

• ezlik3sundaymorning

  Old Hand

  Points: 333

  More actions

  June 12, 2008 at 9:34 pm

  #187882

  Comments posted to this topic are about the item INDEX DEFRAG on SQL SERVER 2005

• psmith-502573

  SSC Enthusiast

  Points: 178

  More actions

  August 5, 2008 at 7:48 am

  #853184

  Awsome. Would you post your sister code for SQL2000?

• Joe Burdette

  Say Hey Kid

  Points: 707

  More actions

  August 5, 2008 at 7:55 am

  #853188

  DBCC SHOWCONTIG...

  This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature. Use sys.dm_db_index_physical_stats instead.

  :unsure:

  ---

  Regards,

  Joe Burdette
  hanesbrands.com

• Gordon-265412

  SSCrazy

  Points: 2898

  More actions

  August 5, 2008 at 8:46 am

  #853228

  You might consider running UPDATE STATS on the object after you've run your INDEXDEFRAG.

  Stats are only updated automatically as part of a REBUILD operation and are not updated when you run INDEXDEFRAG.

  And +1 for moving to the DMVs...(which still runs DBCC SHOWCONTIG behind the scenes, but it's the new way).

  Your friendly High-Tech Janitor...