Window functions are amazing tools that allow statistics, analytics, and mathematical functions to be performed across a data set using less IO and code than with other methods. Not only is this a powerful toolset, but it is one that improves with each new version of SQL Server, adding new parameters, functions, and ways of managing analytic data.
This session will introduce window functions, their syntax, and demo many ways to use them in common analytic scenarios with a goal of providing hands-on experience and code that can be studied, tweaked, and used to solve real-world problems!