Recommendation - Rebuild Index /Partition

• curious_sqldba

  SSC-Dedicated

  Points: 36494

  More actions

  June 18, 2013 at 1:42 pm

  #276473

  I have SQL 2008R2( Enterprise edition). All my tables are partitioned. I need some advice and possibly a script for index maitenance. If my indices are fragmented should i:

  i) Just rebuild the indices or

  ii) Rebuild each individual partition

• Igor Micev

  SSC-Dedicated

  Points: 33110

  More actions

  June 18, 2013 at 3:59 pm

  #1625240

  Hi,

  Use PARTITION = partition_number to rebuild the index on the specified partition or PARTITION = ALL to rebuild it on all partitions.

  If you want to design your own script then you should use the following links:

  http://technet.microsoft.com/en-us/library/ms189858.aspx

  http://technet.microsoft.com/en-us/library/ms188388.aspx

  And you already have scripts:

  http://sqlfool.com/2011/06/index-defrag-script-v4-1/

  http://ola.hallengren.com/

  Regards,

  IgorMi

  Igor Micev,My blog: www.igormicev.com