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 …
Category: Spools
Signs Your SQL Server Execution Plan Is Lying To You: Table Spools
Ashing On The Table
Going Further
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 …
Signs Your SQL Server Execution Plan Is Lying To You: Index Spools
Spool Spool Spoolio
Going Further
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 …
SQL Server Index Spools When You Have An Index
PAUL WHITE IS WRONG
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
Too Much Of A Harmless SQL Server Wait Type Can Be Harmful
Absence Of Evidence
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 …
Eager Index Spool Suggestions For SQL Server
Funtime
I’ve added a couple ideas to User Voice.
The ideas are pretty simple:
Eager Index Spools Should Generate Missing Index Requests
…In query plans where an Eager Index Spool is directly after a data access operator, a missing index
The Coming Froidpocalypse In SQL Server 2019
Legal Notice
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 …
Hey SQL Server Query, What Were You Waiting On?
Surreal Plans
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 …
How Select List Column Sizes Change How Big Spool Operators Are In SQL Server Query Plans
I’ll Use Those Columns Later, Maybe
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 …
Eager Index Spool Annoyances In SQL Server
Don’t Mask Spools
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.