Intelligent Query Processing in SQL Server 2019 by Joe Sack

Please note that this a recorded webinar. It was recorded during live presentation.

Microsoft is introducing the next wave of intelligent query processing improvements that will enhance the performance of workloads that have historically been difficult to tune through classic methodologies. In this session we will cover five new improvements, including row mode memory grant feedback, table variable deferred compilation, batch mode on rowstore, scalar UDF inlining, and approximate query processing. We’ll cover how you can determine if your workloads will benefit from these improvements and discuss how these features fit into your existing Azure SQL Database and SQL Server performance tuning and troubleshooting strategy.