High Performance T-SQL for the Experienced DB Practitioner

2018

TL; DR

Covers performance-centric advanced T-SQL topics.

Session Details

This seminar covers advanced aspects of T-SQL querying and programming with a performance-centric focus. The seminar demonstrates practical uses of T-SQL features, with optimized and polished solutions, many of which were developed by the speaker. The seminar also covers the newest additions to T-SQL in SQL Server 2016 and 2017. The topics covered by the seminar include: the APPLY operator, window functions, (including batch-mode support), pivoting and unpivoting techniques, the OFFSET-FETCH filter, system-versioned temporal tables, string splitting and concatenation with the STRING_SPLIT and STRING_AGG functions, SQL Graph, and more.

Pre-requisites
1 year of experience writing T-SQL code and optimizing queries
Laptop Required:No

3 things you'll get out of this session

Itzik Ben-Gan's previous sessions

Beware of nondeterministic T-SQL code

Nondeterministic calculations are calculations that when invoked repeatedly, return different results given the same inputs. Most T-SQL developers understand what nondeterministic calculations are, but many aren’t aware of the possible implications of using nondeterministic code. This session will show you the many surprising aspects of using nondeterministic code and will provide best practices that will help you avoid getting into trouble.

T-SQL tips and tricks focusing on backdoors and workarounds

This session covers all kinds of T-SQL tips and tricks, focusing on backdoors and workarounds for restrictions and missing features in SQL Server and Azure SQL Database.

This session covers situations where the SQL Server query optimizer does not rely on index order and provides tips and tricks to solve those.

Window Functions

This session covers T-SQL Window Functions.

Boost your T-SQL with the APPLY Operator

The session starts with a brief overview of the operator and it

T-SQL Tips and Tricks

The purpose of this session is to have some fun with T-SQL and to learn practical tips and tricks that will help you improve and optimize your solutions.