Answer
A spill happens when the memory grant is too small and SQL Server must offload intermediate data to TempDB.
Common causes: inaccurate cardinality estimation, heavy sorts, hash joins, window functions.
Want to bookmark, take notes, or join discussions?
Sign in to access all features and personalize your learning experience.
Source: SugharaIQ