Grey Matter Often when query tuning, I’ll try a change that I think makes sense, only to have it backfire.…
Outline In SQL Server 2019, a few cool performance features under the intelligent query processing umbrella depend on cardinality estimation.…
Will Travel If you recall yesterday’s post, we added a couple two column indexes to the Posts table. Each one…
Down With Big Query
Maybe She’s Born With It I get called in to tune a lot of pretty crazy queries. Hands down, the…
Imbalance In yesterday’s post, we looked at a funny situation where a query that spilled was about 5 seconds faster…
Pre-faced Every post this week is going to be about spills. No crazy in-depth, technical, debugger type stuff. Just some…
Expresso Let’s say you wanna get the highest thing. That’s easy enough as a concept. Now let’s say you need…
Don’t Want None One of the many current downsides of @table variables is that modifying them inhibits parallelism, which is…
Goal Posts When you’re measuring query changes to see if your performance changes have made a difference, a common way…