Creating In-Memory tables and natively compiled stored procedures
The previous section was about the top-level architecture of In-Memory OLTP. Knowing the architecture will help us to be familiar with all the steps needed to set up environment for In-Memory OLTP applications, and to create objects within it.
In the following section we will go through creating memory optimized filegroups and then we will create some tables, indexes, and natively compiled stored procedures. All these tasks will be described in the form of walk through examples.
Preparing for In-Memory OLTP
The first step is to create a memory optimized filegroup. The following screenshot shows you how to use the Properties dialog for the database, opened by a right-click on the database in Object Explorer:
As seen in the preceding screenshot, the well known Filegroups tab is divided into three lists. The last list, labeled MEMORY OPTIMIZED DATA, is dedicated to creating the memory optimized filegroup.
Every database can contain...
