SQL Server 2017 Developer???s Guide

Creating a table

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 ...