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.