No, Not More DMVs Though I would be cool with new ones, as long as they’re not memes. When you’re…
Here’s Another One In the first post, I looked at a relatively large table. 50 million rows is a decent…
I was workload testing on SQL Server 2019 RC1 when I ran into a wait type I’d never noticed before:…
Well Have You Ever I mean ever really wondered just how long a query of yours waited on stats to…
The People Who Stare At Plans I’m going to be honest with you, dear readers. I’ve fallen out of like…
Absence Of Evidence There’s a pinky-out saying about wine: don’t hate the grape. People say it because the same kind…
Somewhat Solved This bit of confusion is largely solved in SQL Server 2019 under compatibility level 150, when FROID (scalar…
Common People I know, you probably have questions about CXPACKET. Maybe you look at a wait stats report and nod…
Surreal Plans In a parallel plan with an eager index spool, we can observe EXECSYNC waits for the duration of…
Don’t Mask Spools Certain spools in SQL Server can be counterproductive, though well intentioned. In this case, I don’t mean…