There are some optimizer improvements in SQL Server 2019 that deserve a closer look. Things like Batch Mode for Row Store, Scalar Function Inlining, and Table Variable Deferred Compilation. Check out this course to learn what they help, what they hurt, and most importantly: how they change your job as a query tuner. 100 Minutes, Streamed