4th - 7th March 2015

ExCeL London Exhibition and Convention Centre, London

Whats new in SQL Server 2012-TSQL

With the release of SQL Server 2012, the T-SQL language has been extended further to enable greater productivity and more optimal queries. Following the ANSI SQL standard support has been included for PAGING and SEQUENCES. Many cumbersome sub-queries will be banished by the clutch of new analytic functions, but perhaps the biggest is the window framing extensions. These now allow a true sliding window of data to process such common problems as rolling balances. This will be a high-level look session, but will be diving a bit deeper to highlight some caveats as we go as its not all plain sailing.
Presented by Dave Ballantyne at SQLBits XI
Tags (no tags)
  • Downloads
    Sorry, there are no downloads available for this session.
  • SpeakerBIO
    Dave is a freelance SQLServer database developer / designer and has been working in the IT field for over 20 years,  the past 15 of which has been specialising within SQLServer environment. 
    http://www.clearskysql.co.uk http://dataidol.com/davebally/feed/
  • Video
    The video is not available to view online.