Post reply

Rebuilding Index Large tables in 2005 Database in production need a script

  • January 29, 2009 at 8:51 pm

    #204744

    Hi ,

    I am trying to rebuild the Indexes in Production Database size 1.5 TB and largest table in db is 95 GB.

    I need a script which rebuilds the indexes in large tables first then after small tables.

    Please let me know if you have any scripts or suggestions

    Thanks

    Ichbin

  • January 30, 2009 at 3:39 am

    #935372

    in as much as I can answer this without appearing to offend - if you're asking this question you probably shouldn't really be doing this.

    I'd encourage you find out how to do this yourself, because that way you learn - all the information you require is within the system tables and dmvs.

    I might also ask why you should want to do this in table size order - the largest table may have only one index whilst a smaller table could have lots of indexes thus your time involved would not be related to raw table size. Tables may not be fragmented or indexes may not be fragmented.

    [font="Comic Sans MS"]The GrumpyOldDBA[/font]
    www.grumpyolddba.co.uk
    http://sqlblogcasts.com/blogs/grumpyolddba/

  • January 30, 2009 at 7:07 am

    #935509

    I really appreciate your information.

    I will look into sys table and dmvs ..

    Thanks

    ichbin

Viewing 3 posts - 1 through 2 (of 2 total)

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