DBAs gained the ability to disable indexes in SQL Server 2005. This is a handy little option when you are tuning indexes or consolidating indexes. When you disable an index, you tell SQL Server to basically pretend the index doesn’t exist. Data changes made to the underlying tables are not reflected in the disabled index. […]
I’m pleased to announce my new online course is now up and available: SQL Server Maintenance Plans. This course is almost 2 hours long and covers every aspect of SQL Server’s maintenance plans. You’ll learn what each and every task does and you’ll see examples of how to create plans using both the Maintenance Plan […]
There is a lot of information in the world that people just assume is true because it has been repeated so much. Twinkies have an unlimited shelf life. McDonalds hamburgers have so many preservatives, they will never get moldy. The problem is this information is frequently wrong. But the incorrect information is so widespread and […]
Two months ago I blogged about a procedure I wrote that, if you are using Ola Hallengren’s index maintenance routine, can look for indexes that are being repeatedly defragged. This usually indicates that the fill factor can be adjusted downward so that the index doesn’t need to be defragged every time your maintenance routine runs. […]
I found a bug in SSMS that you may run into when modifying multi-step jobs. If you delete the last step of a job, when you click OK, you will get a pop up saying the On Success action of the (new) last step will be changed from “Go to the next step” to “Quit […]