4th - 7th March 2015

ExCeL London Exhibition and Convention Centre, London

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 dependencies. The seminar also covers suggestions for improvements in SQL Server.
Presented by Itzik Ben-Gan at SQLBits XII
Tags (no tags)
  • Downloads
    Sorry, there are no downloads available for this session.
  • SpeakerBIO
    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 T-SQL Querying (Microsoft Press, 2015) and T-SQL Fundamentals (Microsoft Press, 2012). He has written articles for SQL Server Pro, SolidQ Journal and MSDN. Itzik's speaking activities include TechEd, SQLPASS, IT/Dev Connections, 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.
  • Video
    The video is not available to view online.