Enabling Data Compression – April 2014 Update

Thanks for commenter Srini for catching another problem in how tables with spaces in their names were being handled. This version fixes that.

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

Enabling Data Compression – February 2014 Update

Blog reader cp spotted a pretty big bug in the last version of this routine. Namely, non-clustered indexes were being flagged as no longer present and were therefore not being compressed. This was because the existence check I used, supplying an ID to OBJECT_ID() and checking for a NULL value, will always return a null […]

Vote For SQL Server Service Packs

Brent Ozar Unlimited had a post recently noting that it appears Microsoft has seemed to move away from releasing service packs for SQL Server and instead is only releasing cumulative updates. Given that Microsoft itself warns against installing cumulative updates unless it solves a specific problem you are encountering, most DBAs, including myself, are somewhat […]

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