This page contains the description for my conference session “Powerful T-SQL improvements that reduce query complexity”, and links to the slide deck and demo code used in this presentation.
|Target audience||Database developers with basic T-SQL knowledge.|
|Short description||Explanation of the OVER clause, with basic syntax; plus some advanced usage examples.|
|Duration||The ideal length for this session is 60 – 75 minutes.|
|Full abstract||We’ve all dealt with nightmare queries: huge, twisted monsters that somehow work, despite being ugly and unmanageable. The time has come to tame these beasts, and the solution is available now, in SQL Server 2012.
New T-SQL functions offer out-of-the-box solutions for many problems that previously required complex workarounds. Paging, Running totals, Moving aggregates, YTD, and much more comes at the power of your fingertips in SQL Server 2012. The only thing you need to do is learn the syntax. And that is exactly what this session is all about: a thorough description and explanation of the syntax, and loads of demos to demonstrate how you can use all these new features.
Attend this session to boldly take SQL Server where it has never gone before!
Click here to download a ZIP file containing the slide deck and demo code used in this presentation.
(Note: my presentations tend to evolve over time, so the version you find here may not be an exact match for the version you witnessed)