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.
(no tags)