INDEX DEFRAG on SQL SERVER 2005

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

  • Awsome. Would you post your sister code for SQL2000?

  • 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

  • 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 3 (of 3 total)

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