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 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply