Performance Benefits of new SQL Server 2008 T-SQL features
Play Performance Benefits of new SQL Server 2008 T-SQL features
Almost every T-SQL feature introduced in SQL Server 2008 not only provides programming functionality but offers an increase in performance over performing the same tasks the "old way". In this talk, I'll explore the performance implications of the MERGE statement, table-valued parameters, grouping sets and more. And you'll see the performance implications clearly in the query plans.