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.

Speaker

Sandip Pani's Sessions

Art of Feature Engineering- For Machine Learning

My top 5 new features in SQL Server 2014

New Analytic Functions in SQL server 2012