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