Where are Table Variables Stored? – SQL in Sixty Seconds #095


 

A very popular question we will answer today Where are Table Variables Stored? Recently I have posted few videos on my YouTube Channel about SQL Server performance Tuning and I have received an email from my client of Comprehensive Database Performance Health Check. Let us see the answer to that question in today’s blog post.

A very popular (and incorrect) understanding is that Table Variables are stored in only memory and they do not exist on the disk. This is the reason they are faster and efficient. Actually, it is not true at all. Let us talk about both the misconceptions one