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
Comments (
)
<00>
<01>
<02>
<03>
<04>
<05>
<06>
<07>
<08>
<09>
<10>
<11>
<12>
<13>
<14>
<15>
<16>
<17>
<18>
<19>
<20>
<21>
<22>
<23>
Link to this page:
//www.vb-net.com/VS2015-SQL-Server-Project-Templates/Create-Table-MemOpt-with-Filegroup-sql.htm
<SITEMAP> <MVC> <ASP> <NET> <DATA> <KIOSK> <FLEX> <SQL> <NOTES> <LINUX> <MONO> <FREEWARE> <DOCS> <ENG> <CHAT ME> <ABOUT ME> < THANKS ME> |