Still working on 2012 & 2008 R2, didn't have the time or resources to start working on 2014 🙂

Great question, I liked this one, definitly learnt somthing new 2day about those SUSER_SNAME() & USER_NAME() functions, Thanx Andy.

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

TomThomson (6/5/2014)

---

Te trouble with this question is that 2 3 things store the data for these tables: data, delta, and log. If I destroy the log when the...

+ 1 :w00t:

I never used this "Piecemeal Restore" before, so it was interesting question for me, thanx.

Clive Strong (6/5/2014)

---

I did pick the right option. However, all 3 could be the easiest, depending on your coding style.

Alternatively, you don't need the CAST.

SET @Boolean = @TrueFalse

works just fine,...

Great question & explanation, thanx Andy 🙂

Nice question, thanx! always liked those questions about using SSMS GUI.

Me neither 😎

+1 Agree, @ least I got 2...

SQLServerManager11.msc for SS 2012

SQLRNNR (5/23/2014)

---

Thanks Steve.

And by the way - thanks for continuing this...

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

TomThomson (5/23/2014)

---

Nice easy question. I was quite surprised to see that more than twice as many thought constraints were not allowed as thought indexes were not allowed,...