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

Download this episode

Download Video

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

Format

Available formats for this video:

Actual format may change based on video formats available and browser capability.

    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 continue the conversation, please create a new thread in our Forums, or Contact Us and let us know.