Post reply

Reorganize indexes for all tables in all user databases

  • 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

  • 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"

  • 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

  • May 2, 2016 at 4:08 pm

    #1876099

    Thanks for another good script Harsha.

  • 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.

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply