Practical T-SQL – Efficient Solutions
This full-day seminar covers practical use of T-SQL to
address common tasks efficiently. Often intuitive solutions for common tasks
don’t get optimized well. With some creativity, you can achieve significant
performance improvements. This seminar walks you through such examples,
explaining the reasons for the inefficiencies, and provides efficient
solutions, using powerful tools in the language such as window functions,
APPLY, MERGE, OFFSET-FETCH, sequences and others.
The seminar covers topics such as temporal data, with
efficient handling of temporal intervals; new solutions to gaps and islands
problems; statistical calculations like median; aggregates against partitioned
tables; complexities of generating surrogate keys and copying data with
The seminar also covers suggestions for improvements in SQL
Sorry, there are no downloads available for this session.
Itzik Ben-Gan is a Mentor and Co-Founder of SolidQ. 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 2012 High-Performance T-SQL Using Window Functions and Microsoft SQL Server 2012 T-SQL Fundamentals. He has written articles for SQL Server Pro, SolidQ Journal and MSDN. Itzik's speaking activities include TechEd, SQLPASS, SQLU, SQLTeach and various user groups around the world. Itzik is the author of SolidQ's 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.
The video is not available to view online.