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
T-SQL Tuesday #156 - Wrap Up
Fifteen SQL bloggers answered one question: what turns ordinary code into production code? Here's what they taught me.
Testing the code (T-SQL Tuesday #156)
I picked the T-SQL Tuesday topic and still struggled to answer it. The quality of production code I value most: it has tests.
Production Code (T-SQL Tuesday #156)
I'm hosting T-SQL Tuesday this November. The question: which secret ingredient turns ordinary code into production-grade code?
Scary Scalar Functions - Part Four: Your Environment
You've learned why Scalar UDFs are slow and how to remove them. The last question: where do you even start? Here's how I triage them across a whole environment.
My Toolbox - Everything
Another productivity tool in my toolbox that I use daily. This time it's about file search. Everything will help you find... well, everything.
My Toolbox - Greenshot
Print Screen and Paint never cut it for me. Greenshot did: precise region capture, a real annotation editor, obfuscation, and one-key sharing. Here's the tour.