SQL Server Window Functions

Window functions are a great TSQL tool that will allow you to write simpler, more elegant code. They were first introduced in SQL 2005, and then expanded in SQL 2012. By using TSQL Window functions you can simply your code and make it easier to understand. They allow you to see both aggregations and details all at the same time. In this demo-centric session we will begin with the basics introduced in SQL 2005, then move on to examine the new functions that were added with SQL 2012.

• Steven Ormrod

  1 Recording

  Steven Ormrod is a Database Administrator. He focuses on high-availability and clustering, with a dash of performance tuning thrown in for fun. His environments consist of hundreds of servers spread across multiple countries. He is on the board of directors for the Austin, Texas PASS Chapter and speaks at user groups and SQL Saturdays. Steven holds a BS in Computer Science and a Masters of Education. He is a SQL Server MCM.

• Houston SQL Saturday 43 Recordings

• SQL Server Window Functions 1 Recording