Efficient T-SQL Querying with Itzik Ben-Gan

The main focus of this session was to highlight the new functions that will be available in "Denali". These functions are called Window Functions not to be confused with Windows. They are hugely faster then standard SQL and are focused on the Set Calculations.

Set calculations:
Ranking
Aggregates
Offset
Distribution

Cursors are slow an non-relational in SQL Server not in Oracle.

Window Functions mainly handle the following:
Aggregates: partitioning, ordering & coverage (POC)

Please the following link to review the functions that were reviewed:
TSQL Querying

If the link does not work, which is what I expect, I have a copy of the presentation.

Location:TechEd