Question: are table variables stored in tempdb?
Answer: There is a common misconception that table variables are in memory objects. In reality they are stored in the tempdb database like temporary tables. Like regular variables, table variables are visible only within the batch where they were created.