New SQL Server project templates for VS2015 (Create Table MemOpt.sql)
1: /*
2: $DatabaseMustHaveMemOptFilegroupComment$
3:
4: $DatabaseBucketCountComment$
5: */
6:
7: CREATE TABLE $SchemaQualifiedObjectName$
8: (
9: [Id] INT NOT NULL PRIMARY KEY NONCLUSTERED HASH WITH (BUCKET_COUNT = 131072)
10: ) WITH (MEMORY_OPTIMIZED = ON)
Comments (
)
)
|
|