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.