Reading Time: 1 minute
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.