To create a table in In-memory, follow below steps: Create a database create database test; You must set to AUTO_CLOSE OFF because 'AUTO_CLOSE' is not supported with databases that have a MEMORY_OPTIMIZED_DATA file group. alter database test set auto_close off; The next step would be creating a required file group for memory-optimized tables. To do that, we need to add a memory-optimized file group to test. alter database test add filegroup test_mem contains MEMORY_OPTIMIZED_DATA; Notice the key word MEMORY_OPTIMIZED_DATA, it tells SQL server this file group is in memory and will store memory-optimized objects. Now let's add a file into this file group. alter database test add file(name = 'fileName', filename = 'fileLocation') to filegroup test_mem; Once the memory - optimized data file is ready, we can go ahead and create our first memory - optimized table. use test; create table test_table(id int not null primary key nonclustered hash with (bucket...