Investigation
Unexpected Blocking during the Indexed View Creation
Creating the clustered index on an Indexed View blocked unrelated queries even under RCSI. The cause was Enterprise view matching, fixable with EXPAND VIEWS.
Notes from a TSQL trench
Database stuff,
with a side of memes.
Long-form notes on TSQL performance, Extended Events, Query Store and the tooling around them. Written from the trenches, not the slide deck.
Featured
Latest posts
Efficient Cheating at Lego Video Games
My daughter's LEGO game makes you re-enter every cheat on a clunky six-dial lock. So I built a TSQL solver to find the shortest path through all of them.
SQL Server Module Signing for Secure Cross-Database Access
I keep relearning how to set up secure cross-database access, so here's the reminder: a diagram plus a full follow-along example you can run yourself.
Why my way of writing SQL is superior
Semicolons, leading commas, single-letter aliases. Here is the SQL style everyone loves to argue about, and the practical reasons I refuse to budge.
Query Hash and Query Plan Hash Mapping
Ever struggled to match the binary hash from DMVs and Query Store against the numeric one in Extended Events? Let's fix that for good.
KEEP PLAN Demystified
Ever wondered what the KEEP PLAN hint actually does? The docs are vague, so I tested it against every recompilation threshold to find out.
Extended Events Timezones
Open an XE event file in SSMS and the timestamps stare back at you. Local time or server time? I spun up a container in another timezone to find out.
The SQLBits 2022, or There and Back Again
My first in-person conference, my first time speaking, and a costume that needed a face mask. A SQLBits 2022 recap told in Lord of the Rings quotes.