Before a few days ago, When I was performing query optimization at that time I have seen one warning in the result of SQL Server Query Execution Plan like: “Operator used tempdb to spill data during execution with spill level 2”. I performed RND on this and came to know very interesting reason this warning. … Continue reading SQL Server:Warning in Query Execution Plan, “Operator used tempdb to spill data during execution with spill level 2”