New SQL Server project templates for VS2015 (Create Table MemOpt with Filegroup.sql)
1: /*
2: $DatabaseBucketCountComment$
3: */
4:
5: CREATE TABLE $SchemaQualifiedObjectName$
6: (
7: [Id] INT NOT NULL PRIMARY KEY NONCLUSTERED HASH WITH (BUCKET_COUNT = 131072)
8: ) WITH (MEMORY_OPTIMIZED = ON)
9:
10: GO
11:
12: /*
13: $DatabaseNameTemplateComment$
14: */
15:
16: ALTER DATABASE [$(DatabaseName)]
17: ADD FILEGROUP [$rawname$_FG] CONTAINS MEMORY_OPTIMIZED_DATA
Order a job
Comments (
)
)
Link to this page:
//www.vb-net.com/VS2015-SQL-Server-Project-Templates/Create-Table-MemOpt-with-Filegroup-sql.htm
|
|