Now that we have a filegroup/database that is ready for high-performance workloads, we need to take a moment and consider what limitations there are with the In-Memory OLTP engine.
The following data types are supported:
- All integer types—tinyint, smallint, int, and bigint
- All float types—float and real
- All money types—smallmoney and money
- Numeric and decimal
- All non-LOB string types—char(n), varchar(n), nchar(n), nvarchar(n), and sysname
- Non-LOB binary types—binary(n) and varbinary(n)
- Date/time types—smalldatetime, datetime, date, time, and datetime2
- Unique identifier
This leaves out the LOB data types, that is, XML, max types (for example, varchar(max)) and CLR types (remembering that this is valid for the initial implementation ...