| In Memory OLTP engine limitation in sql2014
In-Memory OLTP is a beautifull feature in sql2014 but it have many limitaion too some of these are given below.
1)It doesnot support all datatye for example geography, hierarchyid, image, text, ntext, varchar(max), and xmL datatype are not supported.
(2)FILESTREAM storage, Database mirroring, FOREIGN KEY,snapshots, triggers, clustered indexes, identity columns, computed columns, CHECK, and UNIQUE constraints are not supported. | | |