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	993	August 30, 2018
New SQL Rule - filter index creation without filter columns in include - performance New rules / language support tsql	0	454	December 24, 2021
New SQL Rule - cursors/whiles - performance New rules / language support tsql	0	567	December 23, 2021
Don't create stored procedures with prefix sp_ New rules / language support tsql	6	3550	December 14, 2018
New SQL Rule - nonSargable queries - performance New rules / language support tsql	0	581	December 23, 2021