2005 Clean Indexes For All Databases on a Server

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 Grant Fritchey » 2005 Clean Indexes For All Databases on a...

2005 Clean Indexes For All Databases on a Server

Rate Topic

Display Mode

Topic Options

Author

Message

Grant Fritchey

Posted Sunday, September 23, 2007 10:59 AM

SSChampion

Group: General Forum Members
Last Login: Yesterday @ 9:49 AM
Points: 13,436, Visits: 25,281

Comments posted to this topic are about the item 2005 Clean Indexes For All Databases on a Server

----------------------------------------------------
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood..." Theodore Roosevelt
The Scary DBA
Author of: SQL Server 2012 Query Performance Tuning
SQL Server 2008 Query Performance Tuning Distilled
and
SQL Server Execution Plans

Product Evangelist for Red Gate Software

Post #401633

Mr. Holio

Posted Wednesday, March 02, 2011 3:00 AM

SSC Eights!

Group: General Forum Members
Last Login: Friday, May 10, 2013 5:58 PM
Points: 843, Visits: 2,558

Good work Grant. You could probably tune a little bit more for example specifying the page_count limit in the clause and modify the line from

SELECT @command = ''ALTER INDEX '' + @indexname + '' ON ?.'' + @schemaname + ''.'' + @objectname + '' REORGANIZE'';

to

SELECT @command = ''ALTER INDEX ['' + @indexname + ''] ON ?.['' + @schemaname + ''].['' + @objectname + ''] REORGANIZE'';

Same for rebuild..Thanks again - will probably use this at some point

__________________________
Allzu viel ist ungesund...

Post #1071794

« Prev Topic | Next Topic »

Permissions