We have seen the lists of limitations at both the table structure level and at the T-SQL language level, it is not all doom and gloom, but these restrictions may be causing some readers to re-think their enthusiasm for memory-optimized objects.
In this section, we will take a look at how traditional disk-based tables compare to their younger brothers, the memory-optimized tables. According to the codename of the In-Memory OLTP feature, Hekaton (Greek for a 100-fold), the new feature should be in the order of 100x faster.
We begin our test by creating a comparable disk-based table and inserting one row into it:
USE InMemoryTest GO CREATE TABLE DiskBasedTable ( UserId INT NOT NULL PRIMARY KEY NONCLUSTERED, UserName VARCHAR(255) ...