I heard an interesting comment from a client and that made me write a blog post. Their point was about table variables, temp tables, and parallel queries.
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 a few videos on my YouTube Channel,
SQL SERVER – Table Variables or Temp Tables – Performance Comparison – SELECT
Today we are going to discuss the performance comparison of table variables and temp tables when we are running SELECT queries.
SQL SERVER – Table Variable or Temp Table – Performance Comparison – INSERT
In this blog post, we will talk about Performance Comparison between Table Variable or Temp Table. Comprehensive Database Performance Health Check
SQL SERVER – Results of Dynamic SQL Into A Variable
Is there a way to store results of dynamic SQL into a variable? A client asked me this during a health check, and here is the answer with sp_executesql.
Memory-Optimized Table Variables
Memory-optimized table variables can avoid tempdb work, but they need a filegroup, indexed table type, memory budget, and workload tests.
Table Variables Survive ROLLBACK: Logging Errors in a Transaction
See how table variables survive rollback to retain error details, then write a permanent error log after a failed SQL Server transaction.