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

MSSQLTips: SQL Server 2019 New Performance Features

On Demand
  • Recorded Date:Apr. 23, 2020
  • Event:On Demand

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. 

Speakers

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.