SQL Server now supports the vast majority of data types in the In-Memory OLTP engine. In fact, the list of supported data types is now so long that it is easier to list the unsupported types instead. The data types that are currently unsupported are:
- Datetimeoffset
- Geography
- Geometry
- Hierarchyid
- Rowversion
- Xml
- Sql_variant
This means that (except for XML), Large Binary Objects (LOBs) are supported, and this covers the max data types varchar(max), nvarchar(max), and varbinary(max). This is great news, as there are many cases where disk-based tables that had only one LOB column, but multiple supported columns, were barred from the In-Memory OLTP engine.
LOB data type support is not limited to tables and indexes—it is now also ...
