Create Memory - Optimized tables

To create a table in In-memory, follow below steps:

1. Create a database
   create database test;
2. 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;
3. 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.
4. Now let's add a file into this file group.
   alter database test add file(name = 'fileName', filename = 'fileLocation') to filegroup test_mem;
5. 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_count = 1000000), msg char(8000)) with (MEMORY_OPTIZED = ON);