Presented by Itzik Ben-Gan
Running Time: 75 min
Window functions allow you to perform data analysis computations elegantly and efficiently. Support for window functions was added in two major milestones. SQL Server 2005 introduced ranking and limited aggregate window functions, and SQL Server 2012 enhanced aggregate window functions with framing options, as well as introduced offset and statistical window functions. This session first explains the design of window functions and then covers practical uses of the functions, demonstrating how you can use them to address business challenges.