Defrag Tables

• rsharma

  SSCarpal Tunnel

  Points: 4865

  More actions

  September 29, 2007 at 8:21 pm

  #179286

  Comments posted to this topic are about the item Defrag Tables

• Brett Burton

  Grasshopper

  Points: 21

  More actions

  April 30, 2008 at 12:18 pm

  #809240

  This works great... thanks for posting it. The only difference that I had to make was to add the table_schema to the cursor.

  DECLARE PKMS_Tables CURSOR LOCAL FOR

  select (table_schema + ''.'' + table_name) as table_name from information_schema.tables

  where table_type = ''base table'' order by 1

  I have tables that are not dbo.

• Ajay Prakash

  SSC Eights!

  Points: 891

  More actions

  February 17, 2009 at 3:41 pm

  #945559

  Good efforts. Adding some rebuild decision criteria eg. Physical fragmentation gone more that 10% or logical fragmentation gone more than 15% might have been better.

  ---

  Kindest Regards,

  Ajay Prakash