SSG Blog
Insights and news from the SQL Solutions Group.
Recent
When your index rebuilds are stuck at 0% (but lying to you)
Ever had a situation where you’re rebuilding a large index but when you check sp_whoisactive, you see 0% complete … and you know the system
The Mysterious Case of the Bloated templog
This is a real customer problem that we’ve dealt with, but it was “edge case” enough that we thought it worth a blog post. Our
Table Variables, TVPs, and the One-Line CPU Fix
Twice in the last two weeks I’ve been pulled into a “the server is pegged at 100% CPU and we don’t know why” fire drill, and twice the fix turned out to be a single hint on one line of code.
“Is anyone still using this database?” How to find stagnant databases
“Is anyone still using this database?” I have been asked this question a surprising number of times lately. The answer can be trickier to find
Intermittent “Cannot Generate SSPI Context” in SQL Server? Here’s the 2022 Kerberos Trap (and How to Fix It)
Windows logins to a SQL Server AG started throwing “Cannot generate SSPI context” — but only sometimes, and only for some people. We solve it.
Full-Text Index Breaking Change in SQL Server 2025
Upgrading to SQL Server 2025 means addressing a full-text index breaking change. We walk you through the steps to do that.