Database Reference
In-Depth Information
You have a database with the appropriate In-Memory filegroup; the next step is
to create an In-Memory table. You will use a
create table
statement for this
specifying the memory-optimized option in the
create table
statement. This is
very similar to the syntax for creating disk-based tables. You will see we have used
the memory-optimized switch so the database engine knows we want to create a
memory-optimized table. By default, this will create a durable table, one that is also
persisted to disk. The checkpoint files created as a part of durable are used in the
event of a server crash and when combined with the databases' transaction log, can
ensure that no data is lost.
There is a limitation on what data types can be used as column data types in
memory-optimized tables. A memory-optimized table supports the following
data types:
• Bit
• Tinyint
• Smallint
• Int
Search WWH ::
Custom Search