Limitations of In-Memory OLTP

Given its memory-intensive nature, and the fact that this is the first release of the feature, there are a number of restrictions for using the In-Memory OLTP engine. Primarily, a memory-optimized table can only have columns of these supported data types:

Image bit

Image tinyint, smallint, int, bigint

Image money, smallmoney

Image float, real ...

Get Microsoft SQL Server 2014 Unleashed now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.