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.

Please share your ideas and opinions about this topic with me, your contribution will add true value to this topic.
If anyone has doubts on this topic then please do let me know by leaving comments or send me an email.

If you like this post, then please share it with others.
Please follow dbrnd.com, I will share my experience towards the success of Database Research and Development Activity.

I put up a post every day, please keep reading and learning.
Discover Yourself, Happy Blogging !
Anvesh M. Patel.

More from dbrnd.com

Leave a Reply

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

Notify of
Sort by:   newest | oldest | most voted

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


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


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