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 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy