Great question. For me, I couldn't decide between the background task running after the ALTER DATABASE command completed or immediately, before the ALTER DATABASE completed, as the background thread is...

That's right, for new writes, but when encryption is set...

Good questions, thanks.

Unfortunately, I rushed the answer and got it wrong! Doh!

Not enough due diligence 🙂

Tom.Thomson (6/15/2011)

---

Nice simple question.

I guess about two thirds getting it right is reasonable, as it's something a lot of people will not have come across. But currently 16%...

Ach... I used that msdn article as my reference before answering the question. However, nowhere does it mention "Software NUMA" but instead uses "Soft-NUMA" (which was not an answer option),...

A 50/50 chance of getting this right and, at this time, 50% got it right LOL!! 😀

Fortunately, I'm in the right half. Cheers Steve.

honza.mf (6/7/2011)

---

DugyC (6/7/2011)

---

honza.mf (6/7/2011)

---

WayneS (6/6/2011)

---

Actually, none of those choices are correct. You get back 50 random GUID values.

1. NEWID() returns a random GUID (aka uniqueidentifier)

2. Select statement has no order...

honza.mf (6/7/2011)

---

WayneS (6/6/2011)

---

Actually, none of those choices are correct. You get back 50 random GUID values.

1. NEWID() returns a random GUID (aka uniqueidentifier)

2. Select statement has no order by clause,...

Yep, 2 different questions with 2 different answers.

Fortunately for me I answered the second question, but I can understand the frustration for those that answered the first.

SanDroid (5/23/2011)

---

GilaMonster (5/23/2011)

---

It's more correctly called the 'plan cache' these days. It used to be called the procedure cache, but since it doesn't just store the plans of procedures, the...

Great question! Nice to start off the week with. Thank You.

Me too 🙂 Cheers Steve, learnt something new again.

Nice, and quite straightforward, question for a Monday morning. Thank you.

Living in the UK was sorely tempted to go for the SQL Server answer, but couldn't find the definite date of release through Google... so went to eliminate the rest...

Great question perfectly worded. It was quite clear that dateformat was relevant to the question and that you were looking for only the 2 statements that would work under all...