SQL 2016–Novedades en tablas in-memory


En el ultimo evento Ignite de 2015 se presentaron algunas de las novedades de SQL Server 2016 entre ellas las mejoras en tablas in-memory.

El siguiente cuadro compara la primer versión de SQL2014 y lo que tendrá SQL 2016

Feature/Limit SQL Server 2014 SQL Server 2016
Maximum size of durable table 256 GB 2 TB
LOB (varbinary(max), [n]varchar(max)) Not supported Supported*
Transparent Data Encryption (TDE) Not supported Supported
Offline Checkpoint Threads 1 1 per container
ALTER PROCEDURE / sp_recompile Not supported Supported (fully online)
Nested native procedure calls Not supported Supported
Natively-compiled scalar UDFs Not supported Supported
ALTER TABLE Not supported / (DROP / re-CREATE) Partially supported / (offline – details below)
DML triggers Not supported Partially supported / (AFTER, natively compiled)
Indexes on NULLable columns Not supported Supported
Non-BIN2 collations in index key columns Not supported Supported
Non-Latin codepages for [var]char columns Not supported Supported
Non-BIN2 comparison / sorting in native modules Not supported Supported
Foreign Keys Not supported Supported
Check/Unique Constraints Not supported Supported
Parallelism Not supported Supported
OUTER JOIN, OR, NOT, UNION [ALL], DISTINCT, EXISTS, IN Not supported Supported
Multiple Active Result Sets (MARS) / (Means better Entity Framework support.) Not supported Supported
SSMS Table Designer Not supported Supported