A very popular question we will answer today Where are Table Variables Stored? Recently I have posted a few videos on my YouTube Channel,
Recently one of my oldest clients asked me a very interesting question about a table variable and SELECT INTO. Let us learn about it.
I had a very interesting conversation with one of my clients about Cardinality Estimation for Temp Table vs Table Variable. Let us discuss it today.
Today we are going to discuss the performance comparison of table variables and temp tables when we are running SELECT queries.
Question: Where is Table Variable Created?
Answer: On Hard Disk and NOT in Memory.
I suggest you read the following blogs