Here is a popular webinar from our recordings: Intelligent Query Processing in SQL Server 2019
Intelligent Query Processing in SQL Server 2019
Speaker: Joe Sack (Principal Program Manager, Microsoft)
Abstract: 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.
Download Event ResourcesClick Here.