Hany Helmy (9/17/2014)

---

I should have went with my 1st guess :angry: but then decided to try all options one by one on my testing server:

1. No query was paused, all...

I thought it was a neat question.

It wasn't that difficult looking up the types of numbers in the answers and I learned something new and interesting.

Yes, I also thought the question was definitely easier once I figured out VCS was "version control system" and not Veritas Cluster Server. :crazy:

Does anyone actually use the PIVOT operator?

I find it so limited that I almost always roll my own using GROUP BY and CASE.

XML... yuck. :sick: :laugh:

Great question, thanks Hugo!

Nifty, thanks Dave!

I can't believe I've never noticed that.

The Alt-F1 method is neat, but only seems to work for tables in your current 'default' database.

Like Sebastian Zeller, I almost always...

Paul Randal has a blog post about doing a tail backup of the log for a database that can't/won't come on-line.

He does a bit fo shuffling to back it up...

Ugh, only got half the answer. I didn't think denying connect would have the same effect but apparently it does. :pinch: 😀

Interesting question. 🙂

You can save your custom colors with specific connections if you use 'registered' servers in SSMS.

I like to set all my production server connections to red, to cut down on...

It specifically says they are using SQL Server 2012 databases on site. The grammar could be considered ambiguous (although that would be a stretch), since it doesn't explicitly rule...

Yea, easiest for me generally means the most reliable and fault-tolerant, but...

Does anyone know if the trace flag should actually be 2312?

I don't have a 2014 instance to test with. 🙁

TomThomson (5/8/2014)

---

Apologies to eveyone for the two stupid errors, one in the question and one in the explanation.

The second answer option should have read "Enterprise and Standard editions"....

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