SQLBits 2013

New Analytic Functions in SQL server 2012

There are new functions introduces with the release of MS-SQL Server 2012. To perform analytic operation in T-SQL , this time Microsoft has added couple of very handy functions.
In this session I'll be exploring all of the below new analytical functions of SQL server 2012.
  • CUME_DIST
  • LEAD   LAG FIRST_VALUE LAST_VALUE PERCENTILE_CONT PERCENTILE_DISC PERCENT_RANK
I'll be explaining how this functions works , where we can use these functions. How we were achieving the same in earlier version and now how simple it is to achieve the same.