SQL server 内存数据库

下面是一个SQLserver 内存数据库的简单例子

注意：C盘根目录需建立一个data目录

--1.创建库 内存表
    CREATE DATABASE imoltp
GO 
  
    ALTER DATABASE imoltp ADD FILEGROUP imoltp_mod CONTAINS MEMORY_OPTIMIZED_DATA ALTER DATABASE imoltp ADD FILE (name='imoltp_mod1', filename='c:\data\imoltp_mod1') TO FILEGROUP imoltp_mod ALTER DATABASE imoltp SET MEMORY_OPTIMIZED_ELEVATE_TO_SNAPSHOT=ON 
GO 

USE imoltp 
GO
    --2 create a durable (data will be persisted) memory-optimized table -- two of the columns are indexed 
    
    CREATE TABLE dbo.ShoppingCart 
    ( ShoppingCartId INT IDENTITY(1,1) PRIMARY KEY NONCLUSTERED,
      UserId INT NOT NULL INDEX ix_UserId NONCLUSTERED HASH WITH (BUCKET_COUNT=1000000), 
      CreatedDate DATETIME2 NOT NULL,
      TotalPrice MONEY 
    ) 
    WITH (MEMORY_OPTIMIZED=ON)
GO

    CREATE TABLE dbo.UserSession ( SessionId INT IDENTITY(1,1) PRIMARY KEY NONCLUSTERED HASH WITH (BUCKET_COUNT=400000),