Rebuilding All Indices

• AndrewSQLDBA

  SSC-Insane

  Points: 21827

  More actions

  April 14, 2013 at 2:53 pm

  #276325

  Hello Everyone

  I hope that everyone is having a very nice weekend.

  I am working to create a maintenance plan. I am looking for some great advice on how one could rebuild all indices. Of course using a stored procedure that is executed by a SQL job. I have a query that will return all index names that are fragmented above a set percentage. I would like to use that to get the name. But after that, I am not sure what the best performing code would be to write to rebuild each index in the list returned.

  I great appreciate any and all advice, suggestions and comments

  Andrew SQLDBA

• J Livingston SQL

  SSC Guru

  Points: 51550

  More actions

  April 14, 2013 at 3:35 pm

  #1606326

  http://ola.hallengren.com/

  ________________________________________________________________
  you can lead a user to data....but you cannot make them think
  and remember....every day is a school day

• AndrewSQLDBA

  SSC-Insane

  Points: 21827

  More actions

  April 14, 2013 at 5:46 pm

  #1606335

  Thank You, this is great.

  Andrew SQLDBA