Thanks, Chris and Solomon, for your responses (and Solomon, for that erudite article!); and I understand what you're both saying, but has anyone taken your theories and applied them in...

I've 'like'd Jeff Moden's reply, but I have to ask the author -- by "We want to use the smallest data storage possible to ensure good performance", you are implying...

Two points to Michal L., and take away two from me for not considering which choice actually represented the "1" answer I was seeking :).

+1. I'm wondering if I first saw the XOR-swap technique in...

+1

Speak for yourself 😀 -- I thought this QotD was EXCEPTional! 🙂

SQLRNNR (10/29/2013)

---

Out of curiosity, I wonder how many people have had this happen to them.

Is the answer rate indicative of experience with this error or do people know this without...

Hugo Kornelis (8/7/2013)

---

Michael_Garrison (8/7/2013)

---

Good question. I missed this because on SQL 2008 R2 I get error with 'c.ID could not be bound'. So I picked SQL would return an error....

Ed Wagner (6/28/2013)

---

I admit I've never used the SOUNDEX or DIFFERENCE functions before, so I got to learn something today. That's always a good way to start the day....

Mike Is Here (6/24/2013)

---

I really didn't care for this question, you must fix all errors regardless of the order they appear.

I selected the wrong answer with the User error, which...

WWDMark (6/6/2013)

---

I was wondering about the collation issue (i.e. case sensitive or not) and as the question didn't specify the collation I took a punt...... and got it wrong! Hey...

kapil_kk (6/3/2013)

---

Lokesh Vij (6/3/2013)

---

Srinivas, The idea here is we are using "TOP(6) WITH TIES", initially "TOP...

Thanks for the question.

Koen Verbeeck (12/30/2012)

---

W00t, easy question to close the year 😀 :w00t:

Not really sure though why a Microsoft resource is so necessary when the question itself is about a pretty universal...