Wednesday, October 19, 2011 10:28 PM
rusanu.com
Understanding Hash, Sort and Exchange Spill events
Certain SQL Server query execution operations are calibrated to perform best by using a (somewhat) large amount of memory as intermediate storage. The Query Optimizer will choose a plan and estimate the cost based on these operators using this memory
Read More...