Intelligent Query Processing in SQL Server 2019 by Joe Sack

Follow us on Twitter
.
.

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.

As a DPG member, you have free access to all our learning resources like videos, Hands-On-Labs & past event resources.


DataPlatformGeeks (DPG) Community
Join the fastest growing community of data & analytics professionals

-Attend all events hosted by DPG, including SQLMaestros Special Events
-Get access to free videos, labs, magazines and host of learning resources
-Download all events & conference material
-Learn new skills. Sharpen existing skills
-Be part of Asia’s Largest Data/Analytics Community
-Opportunity to be a regional mentor & speaker at our events
-Immense technical & professional development

Data Platform Summit 2019 Pre-Registration is now Open

A word from our sponsors

SQLMaestros Master Classes

SQLMaestros Video Courses

SQLMaestros Hands-On-Labs
Want to practice SQL, Azure & BI concepts, step-by-step with exercises, screenshots, instructions & explanations? Get access to 100+ labs covering the entire Microsoft Data Platform stack. Try SQLMaestros Hands-On-Labs – the new way of practical, self-paced learning. Anytime. Anywhere.

SQLMaestros Learning Kits

SQL Server Health Check

Connect with the founder of DataPlatformGeeks/SQLServerGeeks