Microsoft SQL Server has some amazing built in functions that are not only a statistician’s dream, but they can help you write better, faster SQL queries for… pretty much anything. In this session, I will talk about various windowing functions, how to write them, and how they differ from traditional queries at both a syntax and query plan perspective, with lots and lots of demos.