SQLSACT (2/13/2013)
GilaMonster (2/13/2013)
Why would you see a tempDB allocation when something's not spilling to TempDB?From Grant:
All temporary tables (hash/work tables, temp tables, table variables) are written to disk as well as memory, every time
None of the temporary objects are memory only
You're conflating multiple different things into one. Sorts are different. You'll note in the quote you threw out there, I don't say sorts.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning