In general performance is better with temp tables then with table variables. SQL Server Temp Table vs Table Variable Performance Testing If you work with SQL Server, you have probably been asked which is better, a temp table or a table variable? In this tip we look at which is faster a…

New SQL Rule - table variables are used instead of temp tables - performance

pregress (Preben Huybrechts) December 24, 2021, 8:10am 1

In general performance is better with temp tables then with table variables.

Topic		Replies	Views
T-SQL Plugin - New rule for blocking issues in TempDb related to Select * Into # New rules / language support tsql	2	994	August 30, 2018
Does the SonarQube upgrade create temp tables SonarQube Server / Community Build sonarqube	1	335	September 8, 2020
New SQL Rule - cursors/whiles - performance New rules / language support tsql	0	567	December 23, 2021
Use explicite JOIN's rather then implicite New rules / language support plsql , tsql	6	908	November 24, 2018
T-SQL Plugin - new rule for stored procedures New rules / language support tsql	3	1046	August 31, 2018