Excellent question, I learned something new.

I agree, the result is correct but the explanation is wrong. And this is a good example why you should never omit any default statements even it may be tempting...

Nice question, and as everyone else pointed out, the computed columns doesn't need to user more resources. Hugo gave an excellent example on how it could use less resources.

This was really a trick question! I assumed the constraint was correct and it was a bad assumption.

/Håkan Winther

SQL Service AB

My answer to the qustion was "the writer of the question", but i agree that the reader also have a responibility.

I think it was a Good question, and i thank...

good point! 🙂

Remember that there is no such thing as a free lunch! There are always a cost for everything. Denormalization Will cost you disk, maintenance and sometimes the overhead of updating...

Thanks for your QotD! I answered too quick and didn't think of the difference between Len and DATALENGT().

Thanks for an excellent question.

Oleg Netchaev (2/5/2010)

---

JosephDMarsh (2/5/2010)

---

I chose 4, but (as it turns out) I was guessing. (I thought I knew what was going on, chose an answer and clicked 'Submit' before...

Hugo Kornelis (1/25/2010)

---

Good question.

Not a good explanation, though.

"The constriaints prevent some inserts and deletes from occurring." - I did not run the code, but I am pretty sure that all...

Nice question! I learned something from it.

The important point with this question is that you should never take anything for granted and always specify "optional" paramters/statements

Thank you for a great qotd and explanation! Lesson learned.

I got the answer correct, but only because I guessed there was a catch somewhere. I really don't like implicit conversions, especially when I get unexpected results :angry: