2005 Clean Indexes For All Databases on a Server

• Grant Fritchey

  SSC Guru

  Points: 398679

  More actions

  September 23, 2007 at 10:59 am

  #181188

  Comments posted to this topic are about the item 2005 Clean Indexes For All Databases on a Server

  "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
  - Theodore Roosevelt

  Author of:
  SQL Server Execution Plans
  SQL Server Query Performance Tuning

• Mr. Holio

  Hall of Fame

  Points: 3314

  More actions

  March 2, 2011 at 3:00 am

  #1293389

  Good work Grant. You could probably tune a little bit more for example specifying the page_count limit in the clause and modify the line from

  SELECT @command = ''ALTER INDEX '' + @indexname + '' ON ?.'' + @schemaname + ''.'' + @objectname + '' REORGANIZE'';

  to

  SELECT @command = ''ALTER INDEX ['' + @indexname + ''] ON ?.['' + @schemaname + ''].['' + @objectname + ''] REORGANIZE'';

  Same for rebuild..Thanks again - will probably use this at some point

  __________________________
  Allzu viel ist ungesund...