Koen Verbeeck (11/28/2012)

---

The only correct answer is 0.

There are 8 statements in the estimated execution plan, but no queries.

From BOL:

A query is a request for data that is stored in...

@david-2: Wow, nice inspiring post on what I thought was a fairly turgid topic. I feel more motivated to get on with my day's battle against the systems already. I...

This is certainly a good example of a totally unambiguous question as far as I can see - I am surprised at only 34% right so far.

I didn't see anything about that much either - it seems we...

I look at articles like this and must admit I think the author is somewhat full of it. I just wish I had the experience to really assess the NoSQL...

I certainly might have had to think about the NULL one if the select 2 hint had not been there - but hopefully not for too long.

I'll just weigh in here to say it was a fair question from my perspective because it asked about the METHOD, and the intent of this was clear, if not...

@john-2 Arnott

Thanks for the full explanation which certainly helped me understand why I could be said to have got it wrong, which I admit I could not grasp at first....

Nice post GSquared, I enjoyed reading it anyhow, obviously an area you've given a lot of thought to. Indeed it is often a good idea to be outwardly receptive yet...

I liked this question, as I wondered whether anyone would try running the sample code, and what would happen if they did (and I got it right comfortably!). Would you...

I think Mark Rendle is basically right and Uncle Bob did take things a bit far:

"In fact, you go out of your way to make it hard for them to...

Bah humbug - by which you may take it that I had not kept up on this subject. I would have researched it if the version had been specified as...

I thought this one was pretty clear and unambiguous, no trickery just the knowledge / research required to amswer it.

I am not a PM dogramone but I completely agree with you and for exactly the same reasons - essentially a compartmentalist outlook. Or just mentalist. Also, I'm crap at...

Whilst being an introvert I could see this working for a few mornings or afternoons in a week. I enjoy doing that kind of joint development session. Full time though...