Name: Batch mode Adaptive Join in Microsoft SQL Server - Torsten Strauss
Start: 2021-10-13T17:00:00+02:00
End: 2021-10-13T19:00:00+02:00

Batch mode Adaptive Join in Microsoft SQL Server

The batch mode adaptive join feature introduced in Microsoft SQL Server 2017 enables the choice of a hash join or nested loops join method to be deferred until after the first input has been scanned, by using a single cached plan.
In this session you will learn about the requirements, advantages, and disadvantages of using the adaptive join. I will especially focus on the runtime improvements using adaptive joins but also show workloads that lead to a significant performance degradation. We will also see when SQL Server cannot use apaptive joins and what effect adaptive query joins have on the hardware resources like memory allocation and disk IOs.

About the speaker

Torsten Strauß (MCT, MCSE Data Platform, MCSE Data Management and Analytics) has been working with Microsoft SQL Server since the turn of the millennium.
He currently works as Database Engineer and Microsoft SQL Server Evangelist for BP Europe SE and as CEO of inside-sqlserver.
Torsten has delivered more than 100 presentations about Microsoft SQL Server at national and international conferences and user groups and was recognized as a Microsoft Data Platform MVP in July 2018.

Damir Matešić

Torsten Strauß

SQL Server User Group Croatia

Azure Data Tech Groups

Technology

Database Development

Database Professionals

Data Analytics

Data Management

Business Analytics

Business Intelligence

Data Science

Data Mining

Big Data

Batch mode Adaptive Join in Microsoft SQL Server - Torsten Strauss

Online event

Share

SQL Server User Group Croatia

Batch mode Adaptive Join in Microsoft SQL Server - Torsten Strauss

SQL Server User Group Croatia

Details

Members are also interested in