Query to Rebuild index on partitioned table

• sunny.tjk

  SSCertifiable

  Points: 5041

  More actions

  June 13, 2011 at 10:45 am

  #252676

  Hi everyone,

  I'm new to partitioning of tables.

  I've a table which is partitioned on 32 filegroups. I'm guessing all the new data will be added to the 32nd filegroup. Can someone help me to write a query to rebuild the indexes on the partitioned table?

  Thank you.

• Ninja's_RGR'us

  SSC Guru

  Points: 294069

  More actions

  June 13, 2011 at 10:59 am

  #1337913

  No need to reinvent the wheel. This should get you started.

  http://sqlfool.com/2010/04/index-defrag-script-v4-0/