Easy question, make this a multiple choice oR add a third option for "both" to make it slightly harder.

Thanks anyway.

Ahhh! What a trick question, I was so focused on the sum/case part so i didn't even see the UNION part. Personally i think that UNION should have been implemented...

Good question! I learned something new. I don't work with SQL 2005 anymore, but you'll never know when the knowledge is usefull.

Thanks for the Question! Unfortunately I think the answer is incorrect. The execution plan are reusable and re-entrant, but the execution context is not.

Query plans and execution contexts

When a cache-able...

jason.spangler (5/25/2011)

---

You can try using Plan Guides. With SQL Server 2008 , you can create a plan guide based on a query plan handle. Execute the query...

"It depends", in SQL server 2000 it's the millisecond before six, but in later versions it's the microsecond before six. 🙂

Koen Verbeeck (5/26/2011)

---

That...

michael.kaufmann (3/21/2011)

---

tilew-948340 (3/20/2011)

---

I am sorry, but I realy, realy don't understand why D is not good, even if I do your formula.

Why is so that D would have a...

Easy question, and many users have answered correctly, but why do I find a lot of worst practices everywhere?

It is far too common for many developers to write the...

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

I knew the answer, but I havent thought about that this is a good reason to use partitioning.

Very educating question. 🙁

I think its a a nice question, but wrong answer and explanation. I would say that NONE of the above should be the correct answer, because none are guaranteed.

jcrawf02 (10/22/2010)

---

Yeah, that BOL article is misleading, I would argue that PowerPivot is completely unrelated to SQL Server 2008 R2, it depends on Excel 2010 and is a separate web...

Richard Warr (11/16/2010)

---

I thought it was an interesting question as well - currently more people have it wrong than right which shows that we can still be surprised at the...