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 get familiar with all the steps needed to set up the environment for In-Memory OLTP applications and to create objects within it.
In this section, we will create 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 walkthrough 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:
Figure 10.4 – Filegroups page of Database Properties window in SSMS
As seen in the preceding screenshot, the Filegroups tab is divided...
