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, March 24, 2014 1:22 PM
Points: 115, Visits: 125
Comments posted to this topic are about the item INDEX DEFRAG on SQL SERVER 2005
Post #516386
Posted Tuesday, August 05, 2008 7:48 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Wednesday, August 07, 2013 6:04 AM
Points: 27, Visits: 72
Awsome. Would you post your sister code for SQL2000?
Post #546737
Posted Tuesday, August 05, 2008 7:55 AM


SSC-Addicted

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

Group: General Forum Members
Last Login: 2 days ago @ 11:44 AM
Points: 437, Visits: 403
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 05, 2008 8:46 AM
SSC-Enthusiastic

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

Group: General Forum Members
Last Login: Wednesday, April 09, 2014 5:10 PM
Points: 184, Visits: 1,065
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