Dropping a Memory-optimized filegroup

Question

Post reply

Dropping a Memory-optimized filegroup

rhythmk

SSCertifiable

Points: 7271
More actions
June 8, 2014 at 3:04 am

#307976

Comments posted to this topic are about the item Dropping a Memory-optimized filegroup
--rhythmk
------------------------------------------------------------------
To post your question use below link

https://www.sqlservercentral.com/articles/forum-etiquette-how-to-post-datacode-on-a-forum-to-get-the-best-help
🙂
June 9, 2014 at 4:09 am

This was removed by the editor as SPAM

Viewing 11 posts - 1 through 10 (of 10 total)

You must be logged in to reply to this topic. Login to reply

Koen Verbeeck SSC Guru Points: 259105 More actions · Answer 1

Hmmm, déjà vu?

Thanks for the question.

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

pmadhavapeddi22 SSCertifiable Points: 5306 More actions · Answer 2

The same question is asked by Steves on 7th may,2014. Of course, You have mentioned in that forum that you have almost same QOTD

Hany Helmy SSChampion Points: 13921 More actions · Answer 3

{In the first release...}, so that means it has been updated in later releases of Hekaton to ALTER the database.

Thanks & Best Regards,
Hany Helmy
SQL Server Database Consultant

Hugo Kornelis SSC Guru Points: 64790 More actions · Answer 4

Hany Helmy (6/9/2014)
{In the first release...}, so that means it has been updated in later releases of Hekaton to ALTER the database.

The exact wording in Books Online is: "In this first release of In-Memory OLTP (in SQL Server 2014), the only way to remove a memory-optimized filegroup is to drop the database."

The words "in this first release" suggest that Microsoft has plans to improve this story. But I have not seen any publication, blog post, or other mentioning of a fixed plan.

At this time the first release of SQL Server 2014 is the only one we got. I think it's safe to assume that MS is already working on the first service pack, but until someone officially confirms that this particular issue will be addressed there and not postponed until the next major release (or even to "whenever"), I am not going to hold my breath for it.

Hugo Kornelis, SQL Server/Data Platform MVP (2006-2016)
Visit my SQL Server blog: https://sqlserverfast.com/blog/
SQL Server Execution Plan Reference: https://sqlserverfast.com/epr/

free_mascot One Orange Chip Points: 27169 More actions · Answer 5

Repeted but OK. Thanks for the question.

---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."

Ed Wagner SSC Guru Points: 287026 More actions · Answer 6

I think the answer bothers me more than the question being repeated.

Tally Tables - Performance Personified
String Splitting with True Performance
Best practices on how to ask questions

SQLRNNR SSC Guru Points: 281334 More actions · Answer 7

Stewart "Arturius" Campbell (6/9/2014)
Koen Verbeeck (6/8/2014)
Hmmm, déjà vu?
Thanks for the question.
+1

+2

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

rhythmk SSCertifiable Points: 7271 More actions · Answer 8

Thanks for kind replies.

Well when I contributed this question, till then it was not published but later Steve's same QotD published first and it became a revision QotD.Even i posted a reply for Steve's QotD also as this would be repeated again 🙂

--rhythmk
------------------------------------------------------------------
To post your question use below link

https://www.sqlservercentral.com/articles/forum-etiquette-how-to-post-datacode-on-a-forum-to-get-the-best-help
🙂

robert_verell Say Hey Kid Points: 668 More actions · Answer 9

I found this question kinda funny. Dropping the database gets rid of anything in a database, so even if one of the other answers was right, dropping the database would still be a valid answer.