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

Reorganize indexes for all tables in all user databases Expand / Collapse
Author
Message
Posted Tuesday, February 5, 2013 12:03 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, January 16, 2014 2:48 PM
Points: 9, Visits: 435
Comments posted to this topic are about the item Reorganize indexes for all tables in all user databases
Post #1415588
Posted Tuesday, February 12, 2013 10:28 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, March 6, 2014 1:05 PM
Points: 1,334, Visits: 3,068
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.

"Technology is a weird thing. It brings you great gifts with one hand, and it stabs you in the back with the other. ..."
Post #1419094
Posted Thursday, February 14, 2013 6:41 AM


SSC-Enthusiastic

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

Group: General Forum Members
Last Login: Tuesday, July 22, 2014 2:33 PM
Points: 139, Visits: 614
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 »

Add to briefcase

Permissions Expand / Collapse