June 12, 2008 at 9:34 pm
Comments posted to this topic are about the item INDEX DEFRAG on SQL SERVER 2005
August 5, 2008 at 7:48 am
Awsome. Would you post your sister code for SQL2000?
August 5, 2008 at 7:55 am
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:
Joe Burdette
hanesbrands.com
August 5, 2008 at 8:46 am
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