Itzik Ben-Gan


Workshop description

This seminar covers advanced T-SQL querying and query tuning topics. It covers powerful querying tools like window functions, APPLY, OFFSET FETCH, and others; describing how they are optimized, and how you can use them to solve common practical T-SQL querying tasks. The seminar covers both classic query tuning topics like search arguments and join ordering optimization, as well as more recent additions to SQL Server and Azure SQL database like row mode versus batch mode processing, batch mode on rowstore, adaptive and intelligent query processing, table-variable deferred compilation, scalar UDF inlining, and more.

Length of the workshop:

Full day (8 hours)


Form of the workshop

Lecture (slides + demos)




Additional Information

Workshop price:

Regular 1250 PLN +VAT

Last minute  1500 PLN +VAT