One of my favorite questions to ask is about the difference between CTE and Temp tables and which gets stored in memory.