David McKinney (4/29/2013)

---

Interesting idea...but the article has a somewhat incomplete feel to it.

I notice that you never get beyond the 'Introduction' heading.

A little more explanation - perhaps a working example...and...

Hugo Kornelis (4/19/2013)

---

Try what happens if you use a CHECK constraint instead of a trigger to prevent negative values.

By the way, my questions never intentionally contain "tricks". I try to...

OCTom (4/18/2013)

---

For example, one of the best interview questions I ever heard was: "If I asked you to make me a peanut butter and jelly sandwich, what would you...

Hugo Kornelis (4/17/2013)

---

Good question. Not perfect, though.

longer answer options - and especially the inclusion of three of the returned values for the "yes" option. Technically, this makes both answer options...

I think the short takeaway is that IsNumeric just shouldn't be trusted. It looks like a best-practice way to check that a string is a number but it contains...

I like the emphasis on thanking someone for writing a clever equation. Maybe it isn't as popular as y = mx + b, but that one doesn't solve for...

SELECT * FROM table1 t1 LEFT JOIN table2 t2 on t1.id = t2.id

AND t1.flag = 1

SELECT * FROM table1 t1 LEFT JOIN table2 t2 on t1.id =...

For the sake of discussion, I'll...

As a construct for simulating confused code, this question is a fine test.

I couldn't even begin to imagine what simplified version of real use-case this might have been.

If you found...

I wish developers in general would stop using the us vs them paradigm to consider the customer. Assuming the user is an idiot newb who can't be trusted with...

Hugo Kornelis (1/17/2013)

---

Yes, this is standard. And yet, I still would not rely on it. Imagine how your query would suddenly fail if someone adds a column "col1" to table...

Sometimes I answer these questions simply to get easy access to a link to their discussion.

I was hoping for more discussion on why this was a QotD. I agree...

great article. I liked the story it told. I imagine anyone who has been through it before recognized a lot of the issues you mentioned. Anyone who...

Hugo Kornelis (12/12/2012)

---

As happens more often with a Question of the Day: Good idea, but badly executed.

3. Submitters of a Question of the Day should always test their questions on...

TravisDBA (12/10/2012)

---

True Mike, but on the other hand, I have also seen people use this advantage as leverage (hostage) to get what they want or else (raises, bonuses, promotions, job...