We will now take a look at exactly what LOB data types are supported in SQL Server from SQL Server 2016 and higher, and what aspects of these data types need to be considered when using them with memory-optimized objects.
Let's begin by adding a LOB column to our test table using the following code:
USE InMemoryTest GO ALTER TABLE dbo.InMemoryTable Add NewColumnMax VARCHAR(MAX) NULL GO
This follows the same scheme as the previous code examples: adding a LOB column is no different with a memory-optimized table than a disk-based table. At least on the surface, anyway!
Let's take another look at our index meta-data to see how exactly LOB columns are handled by the storage engine, using the following code:
USE InMemoryTest ...