Efficient T-SQL Querying with Itzik Ben-Gan

Sign in to queue

Description

This session covers a group of calculations in T-SQL that can help in addressing a wide variety of querying tasks. It first describes the limitations and shortcomings of traditional, or classic, T-SQL constructs that are used to address common querying tasks. It then explains how T-SQL evolved, and keeps evolving, adding new language constructs that address those limitations very elegantly and efficiently. This session describes the gradual improvements in SQL Server T-SQL support from SQL Server 2005 through SQL Server 11--code-named "Denali".

For more information, check out this course on Microsoft Virtual Academy:

Day:

3

Code:

DBI310

Embed

Download

Download this episode

For more information, check out this course on Microsoft Virtual Academy:

The Discussion

Add Your 2 Cents