Disabling An Index Removes Index Data

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. […]

New Online Course: SQL Server Maintenance Plans

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 […]

TRUNCATE TABLE Does NOT Preclude A Point-In-Time Recovery

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 […]

Monitoring For Endless Index Defragmenting – January 2014

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. […]