Reorganize indexes for all tables in all user databases

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 Harsha Majety » Reorganize indexes for all tables in all user...

Reorganize indexes for all tables in all user databases

Rate Topic

Display Mode

Topic Options

Author

Message

harsha.majety

Posted Tuesday, February 05, 2013 12:03 AM

Forum Newbie

Group: General Forum Members
Last Login: Tuesday, May 21, 2013 9:08 AM
Points: 6, Visits: 397

Comments posted to this topic are about the item Reorganize indexes for all tables in all user databases

Post #1415588

TravisDBA

Posted Tuesday, February 12, 2013 10:28 AM

Ten Centuries

Group: General Forum Members
Last Login: Thursday, May 09, 2013 9:23 AM
Points: 1,288, Visits: 2,996

I really like the script but redoing table indexes on all user databases on a database server at one time is probably a good way to fill up the T-Log or TEMPDB drive, just my .02 cents. I would rather concentrate on running this on only specific high activity databases at a time and only after hours, not every user database on the server. BigGrin

"Technology is a weird thing. It brings you great gifts with one hand, and it stabs you in the back with the other. ... BigGrin

Post #1419094

Your Name Here

Posted Thursday, February 14, 2013 6:41 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Yesterday @ 1:39 PM
Points: 130, Visits: 513

Fair warning:
The "REORGANIZE/ALL" thing doesn't work so well on tables with indexes that have allow_page_locks set off (read: "SharePoint 2010").

Cheers,
Ken

Post #1420026

« Prev Topic | Next Topic »

Permissions