SQL Server 2017 New Features (Not Linux support!)

Speaker: David Williams

Duration: 60 minutes

Track: ITPRO

This session covers the new features in SQL Server 2017 - apart from Linux support

- Using Query Store for automatic tuning of querys which have bad plans (multiple plans with regressions)

- Additional information stored in actual execution plans

- New DMVs e.g. log information, statistics histograms

- Interleaved Execution for multi-statement T-SQL TVFs

- Adapative joins for queries

- Resumable online index rebuild

- Faster non-cluster index builds on memory optimized tables.

- Additional in-memory SQL Surface Area e.g. Computed columns, JSON, CROSS APPLY,sp_spaceused,sp_rename,CASE,TOP N with TIES

- Parallel Redo for memory optimized tables, increases throughput for Always On Availability Groups

- DTC support for Always On Availability Groups

- Cluster-less Availability Groups 

- Minimum Replica Commit Availability Groups

- New CLR strict security

- Graph database queries

- Running Python scripts in SQL Server

- BULK INSERT directly fro

Accompanying Material

No material found.

Back to Top