bitbucket-25253 (7/26/2010)

---

webrunner

Easy enough to find out ...

CREATE TABLE #T(userid INT)

INSERT INTO #T

SELECT 1 UNION ALL

SELECT 1 UNION ALL

SELECT 2 UNION ALL

SELECT 3 UNION ALL

SELECT 4 UNION ALL

SELECT 5...

Good question, interesting to learn that the parentheses make no difference for SELECT DISTINCT.

I have one question, though. I've seen people show me queries where they write SELECT COUNT(DISTINCT...

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...