T-SQL Window Functions in the Realm of Query Logical Processing

Speaker: Ami Levin of SolidQ

We’ve all read so much about the new window functions that were introduced in SQL 2008 and highly enhanced with SQL 2012. What is it about them that makes them such an important construct of the language? To fully understand that, you have to dive into the deep logical aspects of the various processing phases of all SQL queries.

Ami will investigate what T-SQL currently offers for window functions, and also show what's missing and how it can be useful for solving real-life challenges. You'll see demos of how to use windows functions to solve practical, logically challenging queries.

You'll learn

• Query logical processing and how window functions fit

• The support and limitations of the current implementation of window functions in T-SQL

• Techniques for using window functions to solve common challenges

Ami Levin is a consultant with SolidQ. He recently moved to California from Israel, where he led the Israeli SQL Server User Group.Ami is a regular speaker at Microsoft Tech-Ed Israel, Dev Academy, and other SQL Server conferences and blogs at SQL Server Tuning Blog. (http://www.dbsophic.com/SQL-Server-Tuning-Blog/Latest.html)