June 18, 2020 at 12:00 am
Comments posted to this topic are about the item CTE in Tempdb
June 18, 2020 at 10:16 am
That is an interesting tidbit, thanks Steve.
my CTE's seldom do have spool operators in the execution plan, so learned something interesting
____________________________________________
Space, the final frontier? not any more...
All limits henceforth are self-imposed.
“libera tute vulgaris ex”
June 18, 2020 at 1:50 pm
Mostly doesn't matter, but if you're tuning, it's nice to have this tidbit to check
June 27, 2020 at 2:24 am
I was expecting to see recursion listed among the answer options, but realized that recursion was simply a scenario that guarantees a spool operator.
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy