Viewing 15 posts - 1 through 15 (of 42 total)
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...
July 14, 2010 at 7:03 am
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...
July 13, 2010 at 10:39 am
Not sure why this one is tripping folks up, if you just count the delimiters, you can see it will return...
July 2, 2010 at 7:50 am
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...
June 28, 2010 at 9:09 am
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...
June 17, 2010 at 11:45 am
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...
June 9, 2010 at 7:13 am
"A crime against readability" I'll reuse that quote soon enough.
May 28, 2010 at 7:17 am
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...
May 7, 2010 at 9:58 am
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...
May 7, 2010 at 9:32 am
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...
March 25, 2010 at 8:07 am
I was really expecting to see a set-based approach to this formula.
March 24, 2010 at 7:14 am
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,...
March 16, 2010 at 7:59 am
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...
March 8, 2010 at 7:36 am
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...
March 2, 2010 at 12:56 pm
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...
February 25, 2010 at 2:39 pm