Powerful T-SQL improvements that reduce query complexity

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)

By continuing to use the site, you agree to the use of cookies. more information

The cookie settings on this website are set to "allow cookies" to give you the best browsing experience possible. If you continue to use this website without changing your cookie settings or you click "Accept" below then you are consenting to this.