Tag : table variables - SentryOne Team Blog

Tag: table variables

Derik Hammer : Myths : Table variables are always in-memory

Derik Hammer : Myths : Table variables are always in-memory

Guest author Derik Hammer (@SQLHammer) dismisses the common myth that table variables perform better than #temp tables because they are always in memory.

Table Variables in SQL Server 2014

Jason Hall (@SQLSaurus) shows us how table variables have changed in SQL Server 2014, and reminds us that it can be a great learning resource to follow up on questions where we might not immediately have the answer.

Aaron Bertrand : New Trace Flag to Fix Table Variable Performance

Following the recent release of SQL Server 2012 Service Pack 2, SQL Sentry's Aaron Bertrand (@AaronBertrand) takes a first look at a new performance enhancement and trace flag aimed at improving cardinality estimates for table variables and table-valued parameters.