Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

INDEX DEFRAG on SQL SERVER 2005 Expand / Collapse
Author
Message
Posted Thursday, June 12, 2008 9:34 PM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, July 14, 2014 11:19 AM
Points: 115, Visits: 129
Comments posted to this topic are about the item INDEX DEFRAG on SQL SERVER 2005
Post #516386
Posted Tuesday, August 5, 2008 7:48 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Wednesday, May 14, 2014 6:07 AM
Points: 27, Visits: 73
Awsome. Would you post your sister code for SQL2000?
Post #546737
Posted Tuesday, August 5, 2008 7:55 AM


SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Thursday, May 15, 2014 9:36 AM
Points: 437, Visits: 407
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.




Regards,

Joe Burdette
hanesbrands.com
Post #546742
Posted Tuesday, August 5, 2008 8:46 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, July 18, 2014 10:16 AM
Points: 184, Visits: 1,076
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... :)
Post #546788
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse