SQL 2005 IndexDefrag solution

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 Kobus » SQL 2005 IndexDefrag solution

SQL 2005 IndexDefrag solution

Rate Topic

Display Mode

Topic Options

Author

Message

Kobus-452994

Posted Wednesday, May 07, 2008 8:01 PM

Forum Newbie

Group: General Forum Members
Last Login: Friday, May 17, 2013 5:12 AM
Points: 2, Visits: 162

Comments posted to this topic are about the item SQL 2005 IndexDefrag solution

Post #496811

henrik staun poulsen

Posted Tuesday, July 08, 2008 5:01 AM

Ten Centuries

Group: General Forum Members
Last Login: Yesterday @ 11:39 PM
Points: 1,133, Visits: 856

Hi Kobus,

Did you see http://blog.ola.hallengren.com/blog/_archives/2008/1/1/3440068

apart from the special scheduling (2:00 to 8:00) it looks as if it has more features than your procedure.

Best regards,
Henrik Staun Poulsen

Post #529893

Kobus-452994

Posted Tuesday, July 08, 2008 5:36 AM

Forum Newbie

Group: General Forum Members
Last Login: Friday, May 17, 2013 5:12 AM
Points: 2, Visits: 162

i have learned quite a bit since that post...it was 2 months ago...:):)
the most important thing that i leared was that you almost canot defrag a 2000 database on a 2000 SQL server, interestingly when we moved the database, the fragmentation was very high..i db reindexed it on 2005 with alter table and then did the magic bit...sp_updatestatistics...now i just manualy(via a shedule job) run sp_updatestatistics once a day...overkill but still...weird wonderfull world of windows...

Post #529914

henrik staun poulsen

Posted Friday, July 11, 2008 12:14 AM

Ten Centuries

Group: General Forum Members
Last Login: Yesterday @ 11:39 PM
Points: 1,133, Visits: 856

Kobus,

Are you saying that running sp_updatestatistics manually "sorts things out"?
I must try that.

TIA
Henrik

Post #532146

« Prev Topic | Next Topic »

Permissions