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
    Sorry, there are no downloads available for this session.
  • SpeakerBIO
    Sandip_Pani.JPG
    I've more than 5 years of experiance as a SQL/BI developer. I worked in SQL server 2005/ 2008/ 2008R2 and SQL Server 2012. Currently Working for QSI Healthcare (NextGen). Active Memeber 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.