Rebuilding Indexes

• Mike Levan

  SSChampion

  Points: 14201

  More actions

  December 4, 2008 at 2:00 pm

  #126186

  I have seen many scripts which are different from each other for rebuilding indexes also tried some but didnt work well.

  I am looking for a script where checks for fragmentation on an instance and give a result of indexes that are fragmented in different db's and rebuild only those indexes. Also I have table partitions where indexes are also partitioned and i may need to rebuild only those indexes in the partition which are fragmented.

  thanks

• noeld

  SSC Guru

  Points: 96590

  More actions

  December 4, 2008 at 2:49 pm

  #907956

  http://blogs.digineer.com/blogs/larar/archive/2007/07/30/smart-index-defragmentation-for-an-online-world.aspx

  
  * Noel

• Steve Jones - SSC Editor

  SSC Guru

  Points: 737519

  More actions

  December 4, 2008 at 4:30 pm

  #908008

  http://www.sqlservercentral.com/scripts/SQL+Server+2005/63287/

  http://www.sqlservercentral.com/scripts/Indexing/Maintenance+and+Management/