I got it right however I can't see why I would ever use this over an exists/not exists syntax. This is another bit of syntax that I have never seen...

Nice question and explanation. This is something I definitely need to brush up on. Thank you Sourav.

Nice and easy. I'm guessing the 29% who missed it skimmed it too fast? My only critique is that with 3 correct choices out of 4, it made it a...

I have a feeling that this is one of those new functions that I will never actually use. Thanks for the 2012 question though!

Nice question. I got to it after it had been corrected and everything made sense. Glad I didn't have to guess as others did earlier!

Got it wrong but I did learn something so my attempt wasn't all in vain. 🙂

Nice clear question Chirag! Thanks for an easy one to start off the week with.

Nice article. I've had a lot of these same thoughts when reviewing postings. I have been sent to interviews by contract companies before where the actual job requirements were nowhere...

Nice question about a another function that I rarely use. Thanks for the refresher on this!

Nice question. I too had no idea.

Nice and easy, thanks!

Nice question. Thanks Igor.

Also, thanks for the extra information Hugo! I've been considering the uses of columnstore indexes but I don't know that I would get much benefit out of...

Nice question Hugo. I use a lot of case statements so these are always fun to navigate.

Odd behavior. Thanks for the question Steve!

Revenant (5/10/2013)

---

I got it right and I would like to brag about my educated guess, but I am afraid it was just a lucky guess.

Thanks, Yogesh, and have a great...