(SQL) SQL (2014)

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>