Key SQL Server v.Next CTP 1.1 database
engine enhancements include:
- Language and performance enhancements to natively
compiled T-SQL modules, including support for OPENJSON, FOR JSON, JSON
built ins as well as memory-optimized tables support for computed columns.
- Improved the performance of updates to non-clustered
columnstore indexes in the case when the row is in the delta store.
- Batch mode queries now support "memory grant
feedback loops,” which learn from memory used during query execution and
adjusts on subsequent query executions; this can allow more queries to run
on systems that are otherwise blocking on memory.
- New T-SQL language features:
- Introducing three new string functions: TRIM,
CONCAT_WS, and TRANSLATE
- BULK IMPORT supports CSV format and Azure Blob Storage
as file source
- STRING_AGG supports WITHIN GROUP (ORDER BY)s
- Most of the improvements in SQL Server 2016 Service Pack 1 are now available in SQL Server on
Linux, with the exception of a few features such as Polybase
How to Update - See: Update SQL Server on RHEL - CentOS
No comments:
Post a Comment