The T-SQL Cookbook: What's Cool in Microsoft SQL Server 2008 R2 and New in SQL Server Code-Named "Denali"

Sign in to queue

Description

In this session we walk through the new T-SQL-related features that are being delivered in the next version of SQL Server. We show off some cool demos as well as describe the use-cases that these language extensions enable.
For more information, check out this course on Microsoft Virtual Academy:

Day:

1

Code:

DBI318

Embed

Download

Download this episode

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

The Discussion

  • User profile image
    Todd Aspeotis

    Looking forward to FIRST_VALUE and LAST_VALUE. I'm confident writing equivalent functionality using ROW_NUMBER() or TOP but our second tier app support guys (who sometimes venture into customer data) have trouble utilising the ranking functions, since ROW_NUMBER()/TOP ventures into subquery/CTE territory.

Comments closed

Comments have been closed since this content was published more than 30 days ago, but if you'd like to send us feedback you can Contact Us.