Reorganize indexes for all tables in all user databases

• harsha.majety

  SSCommitted

  Points: 1537

  More actions

  February 5, 2013 at 12:03 am

  #394103

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

• TravisDBA

  SSCoach

  Points: 15780

  More actions

  February 12, 2013 at 10:28 am

  #1587121

  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. ...:-D"

• Your Name Here

  SSCrazy

  Points: 2344

  More actions

  February 14, 2013 at 6:41 am

  #1587887

  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

• akljfhnlaflkj

  SSC Guru

  Points: 76202

  More actions

  May 2, 2016 at 4:08 pm

  #1876099

  Thanks for another good script Harsha.

• akljfhnlaflkj

  SSC Guru

  Points: 76202

  More actions

  May 2, 2016 at 4:08 pm

  #1876100

  Your Name Here (2/14/2013)

  ---

  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

  Thanks for the warning.