Trey Staker (7/19/2010)

---

Good Question. I've been stung by this in production early on in my career. Since then I always have specified the length of my varchar's.

I've read...

Good question. In this case I don't consider it a trick question because the lack of a length specification in the statement "DECLARE @TestVar VARCHAR" pointed to behavior based on...

I agree with adzymcfadzy, as several others have - sometimes a bit of both (motivating sometimes, depressing and frustrating other times). I don't think insecurity in itself is good for...

Yes, the question is a repeat of a recent QOTD. I'd understand if it were wiped out and my hard-earned point revoked. 😛

- webrunner

mtassin (7/14/2010)

---

michael.kaufmann (7/14/2010)

---

My gutt told me to go for option 1, but not because of it running faster, but because I wondered why one would change a non-nullable column to...

Great question. I got it wrong, but at least I learned that the two options, though ostensibly only slightly different from each other, have very different results. I need to...

I missed the semicolon in the subquery. To that extent, this question taught me to look for those. It's in my passive SQL vocabulary, so to speak - I (unfortunately)...

sknox (7/12/2010)

---

It doesn't. It checks...

john.arnott (7/12/2010)

---

I cannot answer that authoritatively, but consider that it would make...

"Changes the font to look like cat scratchings" is getting 1% of the answers as of the time I posted this comment. A small but bold cadre of users who...

Good question. Got it wrong, and now I know why.

Thanks,

webrunner

I would love to be able to have that look-over-the-shoulder experience for DBA tasks the way you were able to watch the other roofer. I guess SQLShare videos and other...

mtassin (6/28/2010)

---

webrunner (6/28/2010)

---

Everything necessary regarding the question's typo has already been covered. But I want to thank those who pointed out that "-0" (impossible value, of course, because 0 can...

Everything necessary regarding the question's typo has already been covered. But I want to thank those who pointed out that "-0" (impossible value, of course, because 0 can be neither...

Can I "borrow" one of your red pills? 😛

- webrunner