Why doesn't this query use an index spool?

7yr ⋅

⋅

ADVERTISEMENT

How can I convert the first 100 million positive integers to strings?

7yr ⋅

⋅

Do BIT columns offer any performance advantages for CCIs?

7yr ⋅

⋅

Why does CCI creation on an empty table request a huge memory grant?

7yr ⋅

⋅