Описание тега sql-server-2019

Use this tag for questions specific to the 2019 version of Microsoft's SQL Server.

New Features Of SQL Server 2019

  1. Intelligent Query Processing Enhancements https://stackru.com/images/71339f7efebc4c16b39298bcdb3f34c0cd22a5d7.png
  2. Accelerated Database Recovery (ADR) https://stackru.com/images/200b12373db3023b02e01ee731af0b39c0035cf6.png
  3. AlwaysEncrypted With Secure Enclaves https://stackru.com/images/83bd3510b01d58ff884972f794941180bfa9b8b1.png
  4. Memory-Optimized Tempdb Metadata
  5. Query Store Custom Capture Policies
  6. Verbose Truncation Warnings
  7. Resumable Index Build
  8. Data Virtualization With Polybase https://stackru.com/images/01198d68910e7a8735202787a29b5d145ee9b248.png
  9. Last Actual Execution Plan DMF
  10. Multiple Internal Performance Improvements

Reference: What's new in SQL Server 2019 (15.x)