SQL Server TempDB Spills: How to Fix Sort Warnings and Stop Memory Starvation

It is one of the most frustrating sights in any execution plan: a brilliant yellow warning triangle hovering right over a Sort operator or a Hash Match node. When you hover your mouse over the warning