Window Functions Unleashed
We have all been in situations where writing a GROUP BY query just didn’t do the job, or aggregation over groups required more work than could be fit into one single SQL statement. For that purpose Window functions have been around since SQL Server 2005. But it is first with SQL Server 2012 that the power of using these functions have been truly released. With the introduction of new functions and optimized performance it is now possible to implement solutions which leverage the strength in the language structure without losing performance in the result. In this demonstration packed session I will introduce the concept of Window Functions, show samples of usages and dive into the workings of the optimizer.