Advanced T-SQL Solutions: Unleashing the Powerful Window Functions
Window functions are of SQL’s greatest and most powerful querying constructs, and at the same time, underutilized. They help you address a wide variety of common querying problems in a set-based manner with great efficiency. Window functions are conceptually fairly new and require a new way of thinking. But once you gain knowledge and experience with those, they are natural and intuitive to use. This seminar helps you get over the initial barrier, get comfortable with window functions, and unleash their power to address common problems more efficiently. The seminar covers in detail window functions that are already supported by SQL Server (as of 2005, 2008, 2008 R2), like ranking calculations and window aggregate functions. The seminar also examines standard windowing functions and functionality that SQL Server doesn’t yet support, like distribution and offset functions, as well as ordering and framing options, and provides supported alternatives.
Read Q&A blog on this session.
Solid Quality Mentors
Mentor and Co-Founder
Itzik Ben-Gan is a Mentor and Co-Founder of Solid Quality Mentors. A SQL Server Microsoft MVP (Most Valuable Professional) since 1999, Itzik has delivered numerous training events around the world focused on T-SQL Querying, Query Tuning and Programming. Itzik is the author of several books including "Microsoft SQL Server 2008: T-SQL Fundamentals," "Inside Microsoft SQL Server 2008: T-SQL Querying" and "Inside Microsoft SQL Server 2008: T-SQL Programming." He has written many articles for SQL Server Magazine as well as articles and whitepapers for MSDN. Itzik's speaking activities include Tech·Ed, DevWeek, SQLPASS, SQL Server Magazine Connections, various user groups around the world, and Solid Quality Mentors' events to name a few. Itzik is the author of Solid Quality Mentors' Advanced T-SQL Querying, Programming and Tuning and T-SQL Fundamentals courses along with being a primary resource within the company for their T-SQL related activities.
Register Now for PASS Summit 2010!