SQL Server Hardware: Disk SQL Disk Space There are some optimizer improvements

There are some optimizer improvements in SQL Server 2019 that deserve a closer look

and the One Weird Trick™ a DBA needs to fix it

and Table Variable Deferred Compilation

Things like Batch Mode for Row Store

you'll learn why your SAN really isn't as fast as the brochure from your vendor says it is

SQL Server Hardware: Disk SQL Disk Space There are some optimizer improvementsYou know all those PAGEIOLATCH waits you're seeing? That's your SQL Server reading data from disk because you didn't love it enough. In this course, you'll learn why your SAN really isn't as fast as the brochure from your vendor says it is. You'll also learn what those "15 second I O warnings" in your error log really mean, and the One Weird Trick a DBA needs to fix it. 30 Minutes, Streamed