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
Discover potential obstacles in your design
One query against sys.messages can reveal every edge case SQL Server knows about before you commit to a new design.
Query Store default settings
Query Store comes with default settings - but are they what the documentation says? Let's find out using a simple Extended Events session.
Investigating Errors With Extended Events
Production errors are hard to reproduce. Here's my go-to Extended Events session that captures errors with their full TSQL calling stack.
Out with the old…
WordPress was making me hate blogging. Moving to Hugo, GitHub, and Azure Static Web Apps fixed that.
Work Life Balance (T-SQL Tuesday #141)
Work-life balance has been my focus for the past year and I've already made some changes to my lifestyle. Now it's time to take a look back and evaluate.
Containers and Me (T-SQL Tuesday #140)
It took three tries before containers clicked for me. Each time I learned a bit more, but it wasn't until I had my own project that it all came together.
My Favourite Data Type (T-SQL Tuesday #136)
Brent Ozar asked the SQL community about their favourite data type. My answer surprised even me - sql_variant. Here's why, plus the data type I can't stand.