SQLLunch
12:30 sharp start , downstairs bar at the Golden Fleece EC4N 1SP.
Agenda :
12:30 - 12:31 Welcome and hello
12:31 - 13:30 Remote Presentation : Fabiano Amorim
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.
Speaker bio
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 follow him on twitter: @mcflyamorim