Script Updates From Ola
Ola Hallengren has created some fine database maintenance automation scripts and he supports them with frequent refinements. In his latest round of updates, here are a few things to look at:
Ola's homepage is located here, with release notes located here and documenation here. If you're simply looking for the script, you can find it here.
Thanks for your continued support, Ola!
Other Tools to Examine
I also want to redirect your attention to Raoul Illyes' excellent wait state analysis tool. I know there was quite a lot of talk about using wait states to troubleshoot SQL Server problems at the PASS 2009 Summit. So if you attended any of those popular sessions, take a look at Raoul's free utility here.