Thank you for post, SJ. Interesting one.

Well, thanks to the local help files on SQL-2014, after reading the one of the limitations of memory-optimized file-groups (below), my mind generated list of questions, sequentially, so fast......, I am really not sure if these thought/s are valid or my mind is just babbling around, as I still very very new to this concept and it certainly going to need good amount of time to understand them.

QUOTE

Once you create a memory-optimized filegroup, you can only remove it by dropping the database. In a production environment, it is unlikely that you will need to remove the memory-optimized filegroup.

UNQUOTE

(that word... "unlikely" is bothering me a lot :-))