For the best web experience, please use IE11+, Chrome, Firefox, or Safari

MSSQLTips: SQL Server 2019 New Performance Features

MSSQLTips: SQL Server 2019 New Performance Features
On Demand
  • Recorded Date:Apr. 23, 2020
  • Event:On Demand
MSSQLTips: SQL Server 2019 New Performance Features

SQL Server 2019 has introduced several new features that offer improved performance. The optimizer continues to evolve and get smarter. And there’s no one better to explain it all than SQL Server MVP Joseph D'Antoni.

In this on-demand session, Joseph will show you tricks and tips to use:

  • Scalar Function Inlining
  • Table Variable Optimization
  • TempDB In-Memory Metadata
  • Batch Mode on Rowstore
  • And more

You’ll learn about the best use cases for each of these features, watch demos on how they work and learn about any limitations you may face with SQL Server 2019. 


Joseph D'Antoni is a senior architect and SQL Server MVP with more than a decade of experience working in both Fortune 500 and smaller firms. He is currently Principal Consultant at Denny Cherry and Associates in Malvern, PA. He is a frequent speaker at major tech events and a blogger about all topics technology. He believes that no single platform is the answer to all technology problems. He holds a BS in Computer Information Systems from Louisiana Tech and an MBA from North Carolina State.

Watch Your Free Webcast

Please wait...

triangle-down check
By downloading, you are registering to receive marketing email from us. To opt-out, follow steps described in our Privacy Policy.

reCAPTCHA protects this site. See Google's Privacy Policy and Terms of Use.