SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Database Maintenance

I often see a request for some scripts to help with database maintenance.  Sometimes those questions come in the form of recommendation requests for maintenance plans.  As many already know, there are some really good recommended scripts by Ola Hallengren.  There is also the fantastic index defrag script by Michelle Ufford.

Under normal circumstances, my recommendation would be that the maintenance of your database depends on your environment.  However, that doesn’t always work well.  Sometimes, something is needed quick to get up and in place while you figure things out in your environment and for your database (let’s say you just started a new job or you just inherited the database duties).

Under such circumstances, it would be good to have something ready to go already.  Thus, I recommend using these resources and learn from them.

Index Defrag Script by Michelle

Maintenance Scripts by Ola


Posted by Dukagjin Maloku on 10 March 2011

Jason, thanks for the info and resources!

Posted by Jason Brimhall on 10 March 2011

You are welcome.

Posted by John Sansom on 10 March 2011

Totally agree Jason, these are two brilliant resources.

I'm particularly a big fan of Michelle's Index Maintenance process and have been for several years now. I think it's worth a mention that these guys not only share their work for free but the level of coding quality is exceptional.

If readers decide to use their work be sure to stop by their blogs to say a quick thank you.

Posted by Jason Brimhall on 10 March 2011

Great Points John

Leave a Comment

Please register or log in to leave a comment.