SQL Server 2016 çok yakında yayınlanacak ve bunun akabinde şimdiden In-Memory OLTP için paylaşılan özellikleri SQL Server 2014 versiyonu ile karşılaştırılmış halini sizlerle paylaşıyorum.
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 |
* LOB support will not be available in the CTP shipping this summer.