TODO
Memory optimized table:
create table mem_opt (
id int identity primary key nonclustered,
txt nvarchar(max)
)
with (memory_optimized=on);
Non durable table:
create table non_dur(
id int identity primary key nonclustered,
txt nvarchar(max)
)
with (
memory_optimized=on,
durability=schema_only
);
Memory-optimized table type:
create type dbo.tt_table1 as table (
id int identity,
txt nvarchar(max),
is_transient bit not null default (0),
index ix_c1 hash (c1) with (bucket_count=1024)
)
with (memory_optimized=on)