SQL Server 2017 is a significant leap forward in transforming SQL Server into a versatile platform that offers a plethora of options for development languages, data types, deployment on-premises or in the cloud, and compatibility across various operating systems. This expansion of SQL Server’s capabilities brings its robust features to Linux, Linux-based Docker containers, and the Windows environment.
SQL Server 2017 introduces a wealth of new features, enhancements, and performance optimizations within its Database Engine.
One notable addition is the “Resumable Online Index Rebuild” feature, which allows for the resumption of an online index rebuild operation from where it left off after a failure, such as a failover to a replica or when faced with insufficient disk space. This feature also enables the ability to pause and later resume an online index rebuild operation.
Furthermore, SQL Server 2017 introduces a new generation of query processing improvements. These enhancements adapt optimization strategies dynamically to the runtime conditions of your application workload. This adaptive query processing feature family includes three noteworthy additions: batch mode adaptive joins, batch mode memory grant feedback, and interleaved execution for multi-statement table-valued functions.
Additionally, SQL Server 2017 offers “Automatic Database Tuning,” a feature that provides valuable insights into potential query performance issues, recommends solutions to address them, and, notably, can automatically implement fixes for identified problems
