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.
Sorry, there are no downloads available for this session.
Dave is a freelance SQL Server database architect / designer / developer / consultant and lives near London, England. He is a regular speaker at UK and European events and user groups and currently is supporting the London SQL community by organizing the "SQL Supper" user group. He takes a keen interest in all things SQL and data related and is never happier than picking apart a poorly executing query. He has also created an open sourced add-in for SQL Server data tools (SSDT) called "TSQL Smells". This detects and reports on 'suspect' code within a project and can be found at http://tsqlsmellsssdt.codeplex.com . Outside of work he is husband, father of 3 and exasperated archer.
The video is not available to view online.