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 Neves Amorim
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
http://blogfabiano.com UID:SQLBITS1380SEQUENCE:0 DTSTAMP:20130520T060749Z END:VEVENT END:VCALENDAR