New Analytic Functions in SQL server 2012

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.
Presented by Sandip Pani at SQLBits XI
Tags (no tags)
  • Downloads
  • SpeakerBIO
    Sandip_Pani.JPG
    I've around 7.5 years of experience as a SQL/BI developer.I gave a session on New Analytic Functions in SQL server 2012 during SQLBits XI.I worked in SQL server 2005/ 2008/ 2008R2, 2012 and SQL Server 2014. Currently Working for QSI Healthcare (NextGen).  Active Member of SQLBangalore and BDotNet user groups. 
    http://sqlcommitted.com http://sqlcommitted.com/feed/
  • Video