Discover the key enhancements in SQL Server 2017's Database Engine and learn why upgrading is beneficial in this comprehensive conference talk. Explore improvements in query processing, scalability features, and core relational database functionalities. Gain insights into TempDB optimizations, cumulative updates, new DMVs, online index rebuild limitations, and backup speed improvements. Understand the implications of CLR strict security and whitelisting, clusterless availability groups, and hybrid high availability. Delve into Query Store enhancements, automatic tuning, execution plan improvements, and adaptive query processing techniques. Learn about interleaved execution, table-valued functions, batch mode memory grant feedback, and graph database capabilities. Evaluate the advantages of upgrading to SQL Server 2017 over SQL Server 2016 and address potential risks and concerns.
SQL Server 2017 Database Engine Enhancements - Why You Should Upgrade to It