THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

Kevin Kline

More SQL Server Automation Scripts

If you've read SQL Server Magazine, then you know that I write a monthly column about free SQL Server tools called Tool Time.  I recently wrote about a set of automation scripts from Microsoft's internal MIS group that automates all sorts of regular tasks they perform on their SQL Server's.

Today, I'd like to share some more scripts brought to my attention by Ola Hallengren.  Ola wrote some great scripts for backup, integrity check and index optimization that add to what Microsoft had written. I think that it in some areas has some advantages over Microsoft's solution.

Ola's index optimization stored procedure rebuilds indexes online or offline, index reorganization, statistics update, index reorganization and statistics update or nothing based on fragmentation level and lob existence.  This solution was made about 6 months ago and it has been running in a large production environment since then.  You can see them at:

Ola has put a lot of time in this and would really appreciate your feedback.  You can see more of his work on other topics at
I'd love to hear about any other database automation scripts you may have written.  Be sure to let me know so I can share them with the community.
Published Wednesday, March 26, 2008 4:12 PM by KKline

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS



Kevin Kline said:

I first wrote about useful database maintenance scripts on my SQLBlog account way back in 2008. Hmmm

February 18, 2011 8:18 AM

Leave a Comment


About KKline

Kevin Kline is a well-known database industry expert, author, and speaker. Kevin is a long-time Microsoft MVP and was one of the founders of PASS,

This Blog



Privacy Statement