Setup now allows specifying initial tempdb file size up to 256 GB (262,144 MB) per file, with a warning if the file size is set greater than 1GB with IFI not enabled.An sp_configure option called clr strict security is enabled by default to enhance the security of CLR assemblies.See Graph Processing with SQL Server 2017. New graph database capabilities for modeling many-to-many relationships include new CREATE TABLE syntax for creating node and edge tables, and the keyword MATCH for queries.Automatic database tuning provides insight into potential query performance problems, recommends solutions, and can automatically fix identified problems.See Intelligent query processing in SQL databases.

For this first version of the adaptive query processing feature family, we have three new improvements: batch mode adaptive joins, batch mode memory grant feedback, and interleaved execution for multi-statement table valued functions. A new generation of query processing improvements that will adapt optimization strategies to your application workload's runtime conditions.The IDENTITY_CACHE option for ALTER DATABASE SCOPED CONFIGURATION allows you to avoid gaps in the values of identity columns if a server restarts unexpectedly or fails over to a secondary server.See ALTER INDEX and Guidelines for online index operations. Resumable online index rebuild resumes an online index rebuild operation from where it stopped after a failure (such as a failover to a replica or insufficient disk space), or pauses and later resumes an online index rebuild operation.sp_add_trusted_assembly, sp_drop_trusted_assembly, and sys.trusted_asssemblies are added to support the white list of trusted assemblies (RC1). CLR assemblies can now be added to a whitelist, as a workaround for the clr strict security feature described in CTP 2.0.SQL Server 2017 includes many new Database Engine features, enhancements, and performance improvements.

Getintopc sql server 2017