ronmoses (12/21/2010)

---

For educational purposes, I would genuinely appreciate it if one of the folks who take issue with the "most of the time" factor could illustrate a scenario in which...

In the case of "Null value is eliminated by an aggregate or other SET operation"...

tilew-948340 (12/8/2010)

---

The answer of vk-kirov showed me (if I change the "and" by "or"in the positive subquery) why the answer is nothing in a negative subquery, but is something in...

Patterns that work are reinforced and become easier to implement as well as estimate. That turns into efficiency because projects can be accurately accounted/managed.

Experience of failed projects...

I went with the obvious and straightforward answer; I expected to be wrong.

"Most reliable", "best way to count", etc. are somewhat subjective.

If volumes of code are deployed using cool-counting-trick #4...

...And if it used wrong way it will create harm as anything else. Whith non properly defined indexes performance can be killed. But no one complaining that indexes are bad...

I answered this question using the common misconception as a guide. Usually second-guessing the QotD is guaranteed to trap us.

The discussion of physical vs. logical ordering is...

reminds me of a Freeman Dyson quote: "A good scientist is a person with original ideas. A good engineer is a person who makes a design that works with...

We store html fragments in varchar fields. I learned that smartquotes and emdash need special handling to display properly, so instead I applied special handling to remove them. ...

I think it's also important that developers build baseline diagnostic record into the app. We generally need some way to prove the code during development anyway, but those checkpoints...

re: leading commas. It makes them much more visible than when they're off the right side of the screen. Also, it makes it easier to comment a single...

Why use cursors in any guise? You have a giant pile of data and you want to go through it and take an action on each row? Sometimes...

nearly never. Absolutely never in a public example of maintainable code.

I forced myself to develop a habit of taking the minor pain...

WHERE SvcTypeID IN (1, --Standalone Long Distance

2, --800 Service

...

"I will have to generate a work list for someone to review"

And what is the confidence factor of the reviewer? (since this is likely to be an unpleasant task...