how about:

Schema changes to a 50 million row table should not be done while the DBA is on vacation. Especially when the table in question potentially affects "login" of...

Rather than union all of 4 separate selects against the same base table, would 4 CTE based on each other be better performing? On SQL2000 (no CTE) we tend...

jcrawf02 (7/2/2010)

---

Hugo, thanks again for the excellent re-write and explanation.

Not sure why this one is tripping folks up, if you just count the delimiters, you can see it will return...

Those "trick" QotD are frustrating, but the good discussion that follows illustrates the real value of the community here. This was clearly a human error (it happens). The...

This works very well for centralizing a task comprised of steps on remote servers. A package to manage the remote calls has very little overhead on the machine running...

I can appreciate a get-it-done-today workaround, but wouldn't a better approach be to rewrite the trigger/application layers to provide better tier isolation? I assumed a trigger should be encapsulated...

"A crime against readability" I'll reuse that quote soon enough.

"Ideally Suboptimal"

describes the exact balance point between functionally good enough to call it finished and all the extra work required to make it perfect. Any less effort would obviously...

I haven't implemented this yet, but my thoughts on paging is this:

1) Store each unique combination of request parameters in a table (parent)

2) Run the query, store the results in...

Good question for challenging what we know to be right with an edge case.

I second the opinion that code like this found in production warrants a red-card. Unfortunately we...

I was really expecting to see a set-based approach to this formula.

Not only does this article provide a concise explanation of "It depends" but it also provides a good example of how articles should be written for SQLServerCentral. (well written,...

I suggest if you are suffering through a rewrite anyway that you move the data to tables where it belongs rather than hardcoding data into code. Join the existing...

How can I prove to your system that I am Steve Jones? Well sure, I don't have your password to SQLServerCentral.com - but then you don't have a password...

Isn't it all advertising in one way or another?

I've seen numbers like $60 per qualified contact paid by large companies outsourcing the list gathering task. They're willing to pay...