SQL Server 2014: Create Memory Optimized File Group and Table

In this post, I am showing to create a Memory Optimized Table with allocating dedicated Memory Optimized File Group in SQL Server 2014.

A Previous post, I have discussed basic theory about In-Memory Engine of SQL Server 2014.

SQL Server 2014: What is Hekaton?

This is one of the optimized way to create a Memory Optimized Table in a dedicated File Group of SQL Server.

TSQL Script to create Memory Optimized File group and file:

Create one sample Memory Optimized Table:

This table will create automatically into a Memory Optimized file group.We can access this table like any other table.

Anvesh Patel

Leave a Reply

6 Comments on "SQL Server 2014: Create Memory Optimized File Group and Table"

Notify of
avatar
Sort by:   newest | oldest | most voted
jamison
Guest

Pretty! This has been a really wonderful article.
Thanks for providing this info.

Grace
Guest

Ur website was much useful to us! i’ll thank you u a lot to posting the awesome stuff.

trackback

Good one sir, I want to meet you because I am also working in Hyderabad.

trackback

Something new got to know, thank you for sharing this

trackback

thank you sir for sharing this.

trackback

nice sharing of the article

wpDiscuz