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
My Experience Doing the Online Proctored Exam
My impressions right after taking an online proctored exam. There were a couple of problems I ran into. Hopefully, this article will help you prepare.
Generate XML documents efficiently
Believe it or not, there is a wrong and correct way when it comes to generating XML documents in SQL.