SQL Server 2017 Administrator's Guide

Example 2 – updating data in an In-Memory table

The previous sample involved big data contention with the need for a regular retention policy. This sample is going to start at almost the same point. Let's create an In-Memory table which is similar to the previous one, as follows:

create table SensorData2(SensorId uniqueidentifier not null primary key nonclustered, RecordTime datetime2 not null default(sysdatetime()), WaterFlowRate decimal(7, 2) not null)with(memory_optimized = on)go

As seen in the preceding script, the table does not need an extra surrogate key (compared to the table from the first example), as every sensor is registered once. The rest of table definition remains the same. Bigger changes have to be done in the stored procedure's ...