InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSat, 18 May 2013 18:40:15 GMT20http://www.sqlservercentral.com/Forums/Topic516386-1316-1.aspxYou 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).Tue, 05 Aug 2008 08:46:28 GMTGordon-265412http://www.sqlservercentral.com/Forums/Topic516386-1316-1.aspxDBCC 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:Tue, 05 Aug 2008 07:55:31 GMTJoe Burdettehttp://www.sqlservercentral.com/Forums/Topic516386-1316-1.aspxAwsome. Would you post your sister code for SQL2000?Tue, 05 Aug 2008 07:48:03 GMTpsmith-502573http://www.sqlservercentral.com/Forums/Topic516386-1316-1.aspxComments posted to this topic are about the item [B]<A HREF="/scripts/SQL+Server+2005/63412/">INDEX DEFRAG on SQL SERVER 2005</A>[/B]Thu, 12 Jun 2008 21:34:18 GMTezlik3sundaymorning