you might have used select X,Y,Z,* into #Foo from ....., and Once you have created the temporary table , you can then run this script to pull that table back out if you need to reuse it
Correct SQL Server TempDB Spills in Query Plans Caused by Outdated Statistics
Sergey Gigoyan looks at how to address the warning: Operator used tempdb to spill data during execution with spill level 1.
2016-01-22
3,958 reads