On-Demand:

How Intelligent Query Processing Improves T-SQL Performance

Overview:

Title: How Intelligent Query Processing Improves T-SQL Performance
Duration: 1 hour, 30 minutes

Summary:

Do you write T-SQL for a living and want to improve its performance? Do you wish your 3rd party vendor code would magically go faster? Then you need to learn about Intelligent Query Processing in SQL Server 2019.

While IQP has benefits for both operational and development DBAs, this presentation will focus on T-SQL capabilities. We will explore how IQP impacts Table Variables, Scalar User Defined Functions, and Batch Mode for Rowstore.

When you leave, you'll have a solid understanding of how SQL Server 2019 can improve your T-SQL code performance, potentially without a single code change!

Interested in additional SentryOne webinars?  Check our webinar library.

Watch Now

Andy Yun

Andy Yun

Principal Solutions Engineer

Andy Yun is a SentryOne Principal Solutions Engineer and a former Microsoft MVP. He has been working with SQL Server for over 15 years as both a Database Developer and Administrator. Leveraging knowledge of SQL Server Internals and extensive experience in highly transactional environments, he strives to make T-SQL leaner and meaner. Andy is extremely passionate about passing knowledge onto others, regularly speaking at User Groups, SQL Saturdays, and PASS Summit. Andy is a co-founder of the Chicago SQL Association, co-Chapter Leader of the Chicago Suburban User Group, and part of the Chicago SQL Saturday Organizing Committee.

Companies with the highest demands for database performance choose SentryOne