You’re Short
I ran across something similar in a previous post: Index Spools When You Have An Index.
But here we are again, with the optimizer treating us like fools for our index choices.
Let’s say we have this …
SQL Server Consulting, Education, and Training
I ran across something similar in a previous post: Index Spools When You Have An Index.
But here we are again, with the optimizer treating us like fools for our index choices.
Let’s say we have this …
If this is the kind of SQL Server stuff you love learning about, you’ll love my training. I’m offering a 75% discount on to my blog readers if you click from here. I’m …
If this is the kind of SQL Server stuff you love learning about, you’ll love my training. I’m offering a 75% discount on to my blog readers if you click from here. I’m also …
Ha ha. Just kidding. He’s never wrong about anything.
But he did write about Eager Index Spools recently, and the post ended with the following statement:
…Eager index spools are often a sign that a
There’s a pinky-out saying about wine: don’t hate the grape.
People say it because the same kind of grape can be grown by different people in different places.
Due to many, ahem, local factors, wine made with …
I’ve added a couple ideas to User Voice.
The ideas are pretty simple:
…In query plans where an Eager Index Spool is directly after a data access operator, a missing index
I’ve trademarked: Froidrage, Froidulent, and Froidpocalypse.
If you want to use them, you have to pay me $10,000.
Alright, I’m being told by my lawyer that writing them on cocktail napkins and showing them to confused bartenders doesn’t …
In a parallel plan with an eager index spool, we can observe EXECSYNC waits for the duration of the spool being built.
In a serial plan, we’re not so lucky. There’s no obvious wait that indicates we built …
This is a short post, since we’re on the subject of index spools this week, to show you that the columns that go into the spool will impact spool size and build time.
I …
Certain spools in SQL Server can be counterproductive, though well intentioned.
In this case, I don’t mean that “if the spool weren’t there, the query would be faster”.
I mean that… Well, let’s just go look.