Finding All Gaps In An Identity Column

Have you ever had random inserts into a large table fail? Most of the time, inserts happen fine, but every so often you get a failure with a “primary key violation” error? If your primary key is an integer column with the identity property, you may be wondering how this is possible. What is likely […]

Share

Are Your Availability Group Backups Really Following Your Configured Backup Preferences?

I ran into a problem with Availability Group backups the other day that had me scratching my head for a couple of hours before I finally discovered what was going on. When you set up an Availability Group, one of the settings you can configure is where you want the backups to be made. The […]

Share

Monitoring For Endless Index Defragmenting – October 2015

This is the first of three big script updates this month, so stay tuned! I’ve written before about how my SQL script evolve over time. Well, the script I just published last month has already been updated. I had been deploying the script on all the SQL Servers I manage, rather than just the handful […]

Share