INDEX DEFRAG on SQL SERVER 2005

  • ezlik3sundaymorning

    Old Hand

    Points: 333

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

  • psmith-502573

    SSC Enthusiast

    Points: 178

    Awsome. Would you post your sister code for SQL2000?

  • Joe Burdette

    Say Hey Kid

    Points: 677

    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

    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... 🙂

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply