SQL Server Window Functions

Abstract:

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.

Speakers:

  • 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.

Recorded At:

Recorded on:

May 14, 2016

More Info:

http://www.sqlsaturday.com/514/Sessions/Details.aspx?sid=46986

Tags: