variable Archives - SQL Authority with Pinal Dave

SQL SERVER – Table Variables or Temp Tables – Performance Comparison – SELECT

September 23, 2019

SQL Scripts, SQL Server, SQL TempDB, Temp Table, variable

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

September 21, 2019

Pinal Dave

SQL Performance

SQL Scripts, SQL Server, Temp Table, variable

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

November 20, 2018

Pinal Dave

SQL Tips and Tricks

Dynamic SQL, SQL Scripts, SQL Server, variable

The other day during Comprehensive Database Performance Health Check, I was asked if there is a way to store results of dynamic SQL into a variable. This is a very popular question and let us see the answer to this question in this blog post.