Writing better code with windowing functions on SQL 2012
Once upon a time in a kingdom of darkness… SQL Server 2012 + Windows Functions… and they lived happily ever after…
This session describes the improvements in Windows Functions T-SQL support from SQL Server 2005 through SQL Server 2012. SQL Server MVP Fabiano Amorim will show many samples of how Windows Functions works and explain how they can help-us to write better, more elegant, fast, and efficient code on SQL Server. Functions like, ROW_NUMBER, RANK, DENSE_RANK, NTILE, LEAD, LAG, FIRST_VALUE, LAST_VALUE, PERCENT_RANK, CUME_DIST, OVER Clause, Frame selection and much more. After attend this session you will be able to leave the kingdom of darkness and grow old in a better world of group calculations.
Fabiano is fascinated by the SQL Server Query Processor and the way it works to optimize queries, procedures and functions. Actually Fabiano works in a Brazilian company called Sr.Nimbus as a SQL Server consulting, he also is a SQL Server MVP, MCP for SQL Server 2000, MCTS and MCITP DBD/DBA/BI. His blog is on http://blogfabiano.com you can fallow him on twitter: @mcflyamorim
The video is not available to view online.