SQLServerCentral / Article Discussions / Article Discussions by Author / Discuss content posted by Harsha Majety / Reorganize indexes for all tables in all user databases / Latest PostsInstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSat, 25 May 2013 03:44:53 GMT20RE: Reorganize indexes for all tables in all user databaseshttp://www.sqlservercentral.com/Forums/Topic1415588-2846-1.aspxFair 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,KenThu, 14 Feb 2013 06:41:35 GMTYour Name HereRE: Reorganize indexes for all tables in all user databaseshttp://www.sqlservercentral.com/Forums/Topic1415588-2846-1.aspxI 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. :-DTue, 12 Feb 2013 10:28:26 GMTTravisDBAReorganize indexes for all tables in all user databaseshttp://www.sqlservercentral.com/Forums/Topic1415588-2846-1.aspxComments posted to this topic are about the item [B]<A HREF="/scripts/Indexing/96697/">Reorganize indexes for all tables in all user databases</A>[/B]Tue, 05 Feb 2013 00:03:10 GMTharsha.majety