GilaMonster (2/13/2013)
Grab Kalen's book, Adam Machanic's memory grants video and go over them.Memory grants for sorts are, oddly enough, memory. If the process can't get enough memory, then the sort spills to TempDB. It would be decidedly pointless to request memory, get enough memory for the sort and still write to TempDB.
Oh, and spills are not the same as work tables, temp tables or table variables.
Thanks
Memory grants for sorts are, oddly enough, memory. If the process can't get enough memory, then the sort spills to TempDB
How does this process differ for Hash Joins?
Thanks