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 - New rules

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