T-SQL Window Functions
Window Functions first emerged with the 2005 release and were enhanced in 2012.
They provide a window over the result set and the ability to access data other than the current row.
This means that somethings that may – at first – seem like they need row-by-row processing can be done in one single set-based operation.
The set of window functions available also includes server analytical functions that give the ability to perform statistical analysis.
Come along to this session and see a deep dive into window functions and learn how their use will add to your ability to process data and write more efficient and cleaner queries.