Rebuild Index of all the Indexes in a table?

• SQL_Hunt

  SSC-Dedicated

  Points: 33518

  More actions

  April 18, 2012 at 1:46 am

  #272878

  hi,

  Can you please provide me a good script which will perform the rebuild index activities against the indexes in a table only using a procedure?

  In the procedure I want to define variable with parameters as Fillfactor percent and if fragmentation level > 30%, it will go for Rebulild Index, if less, it will go for ReOrg Index!

  Regards..

  Thanks.

• Gail Shaw

  SSC Guru

  Points: 1004504

  More actions

  April 18, 2012 at 1:51 am

  #1475186

  http://ola.hallengren.com/versions.html

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

  Gail Shaw
  Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
  SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

  We walk in the dark places no others will enter
  We stand on the bridge and no one may pass