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
Hall of Fame
Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)

Group: General Forum Members
Points: 3098 Visits: 1706
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 Guru
SSC Guru (64K reputation)SSC Guru (64K reputation)SSC Guru (64K reputation)SSC Guru (64K reputation)SSC Guru (64K reputation)SSC Guru (64K reputation)SSC Guru (64K reputation)SSC Guru (64K reputation)

Group: General Forum Members
Points: 64513 Visits: 18570
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 (6.5K reputation)SSCertifiable (6.5K reputation)SSCertifiable (6.5K reputation)SSCertifiable (6.5K reputation)SSCertifiable (6.5K reputation)SSCertifiable (6.5K reputation)SSCertifiable (6.5K reputation)SSCertifiable (6.5K reputation)

Group: General Forum Members
Points: 6503 Visits: 2396
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
SSC-Forever
SSC-Forever (40K reputation)SSC-Forever (40K reputation)SSC-Forever (40K reputation)SSC-Forever (40K reputation)SSC-Forever (40K reputation)SSC-Forever (40K reputation)SSC-Forever (40K reputation)SSC-Forever (40K reputation)

Group: General Forum Members
Points: 40515 Visits: 19811
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.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)

Group: General Forum Members
Points: 2699 Visits: 616
nice question..
thanks steve.
Raghavendra Mudugal
Raghavendra Mudugal
Hall of Fame
Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)

Group: General Forum Members
Points: 3312 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
SSCarpal Tunnel
SSCarpal Tunnel (4.5K reputation)SSCarpal Tunnel (4.5K reputation)SSCarpal Tunnel (4.5K reputation)SSCarpal Tunnel (4.5K reputation)SSCarpal Tunnel (4.5K reputation)SSCarpal Tunnel (4.5K reputation)SSCarpal Tunnel (4.5K reputation)SSCarpal Tunnel (4.5K reputation)

Group: General Forum Members
Points: 4451 Visits: 1117
Drop the database, hmm, learnt something new.
Hugo Kornelis
Hugo Kornelis
SSCoach
SSCoach (18K reputation)SSCoach (18K reputation)SSCoach (18K reputation)SSCoach (18K reputation)SSCoach (18K reputation)SSCoach (18K reputation)SSCoach (18K reputation)SSCoach (18K reputation)

Group: General Forum Members
Points: 18399 Visits: 12426
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