INDEX DEFRAG on SQL SERVER 2005

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by Scott Dexter » INDEX DEFRAG on SQL SERVER 2005

INDEX DEFRAG on SQL SERVER 2005

Rate Topic

Display Mode

Topic Options

Author

Message

ezlik3sundaymorning

Posted Thursday, June 12, 2008 9:34 PM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, May 02, 2013 4:12 PM
Points: 115, Visits: 110

Comments posted to this topic are about the item INDEX DEFRAG on SQL SERVER 2005

Post #516386

psmith-502573

Posted Tuesday, August 05, 2008 7:48 AM

SSC Rookie

Group: General Forum Members
Last Login: Saturday, September 29, 2012 11:11 AM
Points: 27, Visits: 70

Awsome. Would you post your sister code for SQL2000?

Post #546737

Joe Burdette

Posted Tuesday, August 05, 2008 7:55 AM

SSC-Addicted

Group: General Forum Members
Last Login: Monday, May 20, 2013 8:37 AM
Points: 437, Visits: 354

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

Regards,

Joe Burdette
hanesbrands.com

Post #546742

Gordon-265412

Posted Tuesday, August 05, 2008 8:46 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, March 07, 2013 5:45 PM
Points: 184, Visits: 1,029

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 »

Permissions