SQL Server 2017 Administrator's Guide

Example 1 – inserting incoming data into In-Memory tables

This first sample shows probably the most traditional method of data capture for production tracking or monitoring systems. It originates from traditional disk-based data processing. What we need is a table living in In-Memory and also very simple natively compiled stored procedures to achieve the best possible performance.

Our first code sample shows the table creation. We can still have to keep in mind that the database prepared for such table must have memory optimized filegroup:

create table SensorData(Id bigint not null identity primary key nonclustered, SensorId uniqueidentifier not null, RecordTime datetime2 not null default(sysdatetime()), WaterFlowRate decimal(7, 2) not null ...