Categories
Database Development

Why does TempDB spill happen even though statistics are correct?

I read a great article published by Brent Ozar and came up with some questions related to memory grant. I am unable to address my questions in the comment section of his article, so I thought to get any help from here. Question: How much data is spilled into disk? 400 MB or 60 MB(7643KB*8)? […]