Defrag Tables

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss Content Posted by Rahul Sharma » Defrag Tables

Defrag Tables

Rate Topic

Display Mode

Topic Options

Author

Message

rsharma

Posted Saturday, September 29, 2007 8:21 PM

SSC Veteran

Group: General Forum Members
Last Login: Friday, May 11, 2012 3:58 AM
Points: 265, Visits: 184

Comments posted to this topic are about the item Defrag Tables

Post #404528

Brett Burton

Posted Wednesday, April 30, 2008 12:18 PM

Forum Newbie

Group: General Forum Members
Last Login: Friday, June 12, 2009 3:40 PM
Points: 1, Visits: 5

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.

Post #493176

Ajay Prakash

Posted Tuesday, February 17, 2009 3:41 PM

Valued Member

Group: General Forum Members
Last Login: Wednesday, May 15, 2013 2:43 AM
Points: 53, Visits: 178

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

Post #658945

« Prev Topic | Next Topic »

Permissions