I had no idea that piecemeal restores were a real option. I thought it was slang for some sort of other restore process. Learned something new today. Thanks for the...

Nice one! Thanks.

Neat function. It will be nice to try this one out if I ever get to actually upgrade to 2012.

Better than duct tape!

I chose filestream only because the last answer didn't seem correct either. The word "separate" threw me off. Oh well, nice question about a new topic!

Never used that proc before. Thanks for the question Andy!

SQLRNNR (5/23/2014)

---

TomThomson (5/23/2014)

---

SQLRNNR (5/23/2014)

---

I disagree that this is an easy question. There may be two obviously correct options but there is a third option that is correct.

Temp tables can...

Interesting question. Thanks Igor. I guessed wrong and then did some testing on my SQL 2008 R2 box and got the same results as the correct answer choices.

Interesting question Andy! I hope to never work on a table where 253 FKs is a reality. I think the most I have ever seen was about 10.

Thanks for the tricky question. I had to read over the documentation a few times before choosing.

I don't have an instance of 2014 to try this on. Still confused on what the most "correct" answer really is here. The references I looked up pointed at 9481...

I didn't put enough thought into this one. I was leaning towards the login having granted permissions to another login and then took the bait on the offline databases. Should...

Nice question. I forgot all about the WITH TIES option.:-)

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...

Imagine what that would look like in a busy OLTP...