Home » sql server 2016 new features for DBA

sql server 2016 new features for DBA

SQL Server 2016 New Features In-Memory OLTP enhancements

SQL Server 2016 New Features In-Memory OLTP enhancements

1. SQL Server In-Memory OLTP – Parallel and heap scan for memory-optimized tables

Memory-optimized tables and indexes in In-memory optimized tables are supported to parallel scan. This improves the performance of queries. Heap scan is also supported which can be performed in parallel which is scanning of all the rows in a table using the in-memory heap data structure used for storing the data.

2. SQL Server In-Memory OLTP -Transact-SQL/TSQL Improvements for memory-optimized tables

a.UNIQUE constraints and indexes are supported.
b.FOREIGN KEY references between memory-optimized tables are supported.
c.CHECK constraints are supported.
d. NULL values are allowed
e.Trigger’s are supported.

3. SQL Server 2016 In-Memory OLTP Storage

Read the rest