O'Reilly logo

Brad's Sure Guide to SQL Server Maintenance Plans by Brad McGehee

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 8. Reorganize Index Task

In some situations, the Reorganize Index task, coupled with the Update Statistics task (covered in the next chapter), provides a useful alternative to the Rebuild Index task. But before I go any further, let me state again, very clearly, that you should not run the Reorganize Index task if you are running the Rebuild Index task. These tasks perform essentially the same function, and there is no point in repeating the same step. Unfortunately, the Maintenance Plan Wizard is not smart enough to prevent you from making this mistake, and will let you create and schedule both of them.

Since Reorganize Index works to achieve essentially the same goal as the Rebuild Index task, namely maintaining the health of your database ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required