SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Removing Memory-optimized tables


Removing Memory-optimized tables

Author
Message
Dana Medley
Dana Medley
SSCrazy
SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)

Group: General Forum Members
Points: 2486 Visits: 1696
Great question Steve. I had to do some research to figure it out, so I definitely learned something today.



Everything is awesome!
SQLRNNR
SQLRNNR
SSC-Dedicated
SSC-Dedicated (31K reputation)SSC-Dedicated (31K reputation)SSC-Dedicated (31K reputation)SSC-Dedicated (31K reputation)SSC-Dedicated (31K reputation)SSC-Dedicated (31K reputation)SSC-Dedicated (31K reputation)SSC-Dedicated (31K reputation)

Group: General Forum Members
Points: 31828 Visits: 18550
Good question.

My problem is I am not certain that this implementation of the feature is very good. I can find where people would want to remove the in-memory filegroups. Needing to restore the database in order to remove the filegroups is a complete pita.



Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server, MVP


SQL RNNR

Posting Performance Based Questions - Gail Shaw

Ken Wymore
Ken Wymore
SSCertifiable
SSCertifiable (5K reputation)SSCertifiable (5K reputation)SSCertifiable (5K reputation)SSCertifiable (5K reputation)SSCertifiable (5K reputation)SSCertifiable (5K reputation)SSCertifiable (5K reputation)SSCertifiable (5K reputation)

Group: General Forum Members
Points: 5032 Visits: 2371
Thanks for the question Steve! I had to look this up too. Now knowing that the database would have to be dropped if I wanted to remove the filegroup, I would definitely want to test this out on a dev instance for a while before trying it in production!
Luis Cazares
Luis Cazares
SSCoach
SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)

Group: General Forum Members
Points: 16204 Visits: 19059
sestell1 (5/7/2014)
Hmph. Since the question asked how to remove the filegroup from the database, I didn't consider dropping the database a viable option.

"Memory-optimized filegroups cannot be deleted."
http://msdn.microsoft.com/en-us/library/dn284308(v=sql.120).aspx


+1
It's like asking how to remove a SQL Server instance from your server and you say that you can do it by reinstalling the OS. It works, but it's not exactly what you need.


Luis C.
General Disclaimer:
Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?


How to post data/code on a forum to get the best help: Option 1 / Option 2
pchirags
pchirags
SSCrazy
SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)

Group: General Forum Members
Points: 2339 Visits: 615
nice question..
thanks steve.
Raghavendra Mudugal
Raghavendra Mudugal
SSCrazy
SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)

Group: General Forum Members
Points: 2070 Visits: 2958
SQLRNNR (5/7/2014)
... ... pita.


Well, I have a tendency of shortening the sentence by picking the beginning letter of each word in that and create a abbreviation or acronym, recently few minutes ago I was in a situation where I heard myself saying the expanded version, normally, and then in next moment I was working on shortening it and I came across THAT word... and at the same time ... I remember reading mentioned here on the post. Well now it all makes sense.. and before I was wondering what the "plant yielding strong fibre"* has to do with the memory-optimized tables.

* http://www.bing.com/search?q=define%3A+pita&src=IE-TopResult&FORM=IE11TR&conversationid=

ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.
Hany Helmy
Hany Helmy
Hall of Fame
Hall of Fame (3K reputation)Hall of Fame (3K reputation)Hall of Fame (3K reputation)Hall of Fame (3K reputation)Hall of Fame (3K reputation)Hall of Fame (3K reputation)Hall of Fame (3K reputation)Hall of Fame (3K reputation)

Group: General Forum Members
Points: 3007 Visits: 1117
Drop the database, hmm, learnt something new.
Hugo Kornelis
Hugo Kornelis
SSChampion
SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)

Group: General Forum Members
Points: 10805 Visits: 11966
Hmmm, I did get it right but I didn't really like the question. Or rather, the answer options; the question itself is great.

I'd say that both "drop the DB" and "you can't" are correct. And if you really want to split hairs, you could even say that "you can't" is the only correct option, because the question was on removing the FG from the DB; dropping the DB removes the entire DB, with all its FGs, it removes the FG from existence but not from the DB.


Hugo Kornelis, SQL Server MVP
Visit my SQL Server blog: http://sqlblog.com/blogs/hugo_kornelis
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search