Like most things performance related in SQL Server, it depends. Let me start with a common misconception on table variables.  I regularly see developers using @Temp table variables because “they are in memory”.  I cringe every time I hear this.  Why do I cringe? Because that’s not true.  Table variables are persisted just the same […]