Category: Table Variables

Strongly Type Those Table-Valued Parameters

Jonathan Kehayias shows a simple fix to C# code that can improve performance and throughput of workloads using table-valued parameters.

January 22, 2020 | SQLPerformance.com | SQL Server, Table Variables 0

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

April 4, 2017 | SQLPerformance.com | Performance, T-SQL, Table Variables 0

Jason Hall shows us how table variables have changed in SQL Server 2014 and reminds us how helpful it can be to follow up on hard questions.

September 18, 2014 | Jason Hall | T-SQL, SQL Server, Indexes, Table Variables 4

Following the recent release of SQL Server 2012 Service Pack 2, SQL Sentry's Aaron Bertrand (@