Platinum Sponsor

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 years of experience as a SQL/BI developer. I worked in SQL server 2005/ 2008/ 2008R2 and SQL Server 2012. Currently Working for QSI Healthcare (NextGen). Regional mentor for SQLServerGeeks.com for Bangalore chapter. Active Member of SQLBangalore and BDotNet user groups. 
    http://sqlcommitted.com http://sqlcommitted.com/feed/
  • Video
    The video is not available to view online.
  • Session Files Explorer
    The network name cannot be found.