The funny thing is that personally, I moved away from doing all data access and manipulation by means of stored procedures. For me, the change has been a blessing as...

Very likely I will keep working in IT in one capacity or another.

Even if just because that is where my non-age limited talents are and I got a proven track...

mtassin (4/26/2012)

---

Dynamically creating that query will also avoid plan re-use. The IN clause will be different every time. In that case, if I were using SQL 2008 I'd...

As usual...it depends :).

Mostly on when to use it, because if the nature of the problem you try to solve is dynamic,...

Maybe it is me overreacting here, if so I stand corrected, but I think this article should have been screened out and not get published.

I do not know the formal...

ben.kimball (4/26/2012)

---

Seems a good example of how tired and overloaded SQL syntax has become.

SQL syntax has become too obtuse for what we need it to do these days. Need a...

kevriley (4/26/2012)

---

Peter-757102 : whilst I agree you that the observed effects are down to misunderstanding the order by clause, and not some sort of misbehaving case statement, I don't understand...

Functional speaking, ... it can, ... but see my earlier response as to why you should NOT do that! What you can do, and problablly...

sknox (4/26/2012)

---

*facepalm*

Let me see if I can explain this much more simply:

ORDER BY takes as its arguments a set of expressions, each optionally followed by a direction indicator, separated by...

Not to mention some changes in delta scripts are irreversible (or very difficult/costly to make them), which in fact favors a snapshot methodology. You could with every revision copy the...

I am not debating whether it will be the faster method or not, it's simple well thought out contruction will make sure it is. But it can potentially have much...

Jeff Moden (3/15/2012)

---

peter-757102 (3/15/2012)

---

Jeff, did you receive any news regarding the performance characteristics of the code (or variations) on SQL Server 2012?

And on the extra bright side, in a few...

Jeff, did you receive any news regarding the performance characteristics of the code (or variations) on SQL Server 2012?

And on the extra bright side, in a few months I will...

Actually, while XML in readable form is pretty bloated due to it being so verbose (hard to argue with you there). For storage however it can be very compact when...

Silly hierarchies?

I know a lot, if not most people creating XML are quite bad at the modeling and encoding part of their data. For example, nearly all XML documents I...