Category: Table Variables

Itzik Ben-Gan starts a new series discussing the fundamentals of table expressions, a commonly misunderstood feature in T-SQL.
Jonathan Kehayias shows a simple fix to C# code that can improve performance and throughput of workloads using table-valued parameters.
Guest author Derik Hammer dismisses the common myth that table variables perform better than #temp tables because they are always in memory.
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

Top Categories

See all

Get the best SQL query analysis and optimization tool – free!

Plan-Explorer-logo-RGB-800px
  • Index Analysis Sandbox
  • Statistics Analysis with Histogram
  • Management Studio Add-in
  • Plan Diagram
  • Deadlocks
  • History and Comments
Free Download Learn More