Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SQL 2005 IndexDefrag solution Expand / Collapse
Author
Message
Posted Wednesday, May 7, 2008 8:01 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, May 30, 2014 5:01 AM
Points: 2, Visits: 177
Comments posted to this topic are about the item SQL 2005 IndexDefrag solution
Post #496811
Posted Tuesday, July 8, 2008 5:01 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Wednesday, July 2, 2014 5:14 AM
Points: 1,345, Visits: 981
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
Posted Tuesday, July 8, 2008 5:36 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, May 30, 2014 5:01 AM
Points: 2, Visits: 177
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
Posted Friday, July 11, 2008 12:14 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Wednesday, July 2, 2014 5:14 AM
Points: 1,345, Visits: 981
Kobus,

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

TIA
Henrik



Post #532146
Posted Tuesday, December 17, 2013 8:40 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: General Forum Members
Last Login: Today @ 2:50 PM
Points: 36,711, Visits: 31,159
henrik staun poulsen (7/8/2008)
apart from the special scheduling (2:00 to 8:00) it looks as if it has more features than your procedure.


Which is why some people are driven to write their own.

@Kobus,

That does bring up something important though. The article text says "2 to 4" but the code is actually setup for "2 to 8". If you have this code in production, that may cause you a problem sometime in the future.


--Jeff Moden
"RBAR is pronounced "ree-bar" and is a "Modenism" for "Row-By-Agonizing-Row".

First step towards the paradigm shift of writing Set Based code:
Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column."

(play on words) "Just because you CAN do something in T-SQL, doesn't mean you SHOULDN'T." --22 Aug 2013

Helpful Links:
How to post code problems
How to post performance problems
Post #1523736
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse