Viewing 15 posts - 2,956 through 2,970 (of 3,348 total)
Sjimmo and Steve,
It's like you say, but then it goes even a step further.
The UPDATE() function does, as you indicate, not check if any values actually changed.
But it also doe...
December 2, 2009 at 1:04 pm
anil.kubireddi (12/2/2009)
What is the output of the following code (disregarding "X row(s) affected"):
CREATE TABLE TriggerTest (Value int)
GO
INSERT INTO TriggerTest VALUES (1)
GO
CREATE TRIGGER tr_TriggerTest...
December 2, 2009 at 6:13 am
bitbucket-25253 (11/19/2009)
November 19, 2009 at 1:58 pm
Well, I've allowed myself to be distracted into a discussion on what can be deducted from particular operators in the execution plan and whether or not the quirky update can...
November 10, 2009 at 4:52 pm
Jeff Moden (11/10/2009)
November 10, 2009 at 4:23 pm
Jeff Moden (11/10/2009)
Hugo Kornelis (11/10/2009)
... and shaved off another half a mintue - 3:58.
Heh... very cool optimization of the cursor, Hugo. You've managed to upgrade it to only...
November 10, 2009 at 3:41 pm
Hi again!
I've now finished the article, and I just want to post two more comments before I start trying to adapt my set-based iteration method for this specific problem.
First: In...
November 10, 2009 at 3:15 pm
Hi Jeff,
Still reading the article. Slowly, though, as I had to do the shopping - cooking - eating - taking kids to bed routine in between. But here are two...
November 10, 2009 at 1:58 pm
Thanks Jeff.
I also found a TEMPDB (fully upper case) and a Master when I ran the code to create the million row table. If you have a chance, you might...
November 10, 2009 at 7:26 am
Hi Jeff,
Thanks for doing a rewrite of this article.
Just a few comments before I start really reading the article:
1) Being one of the people who tried to grill you over...
November 10, 2009 at 6:35 am
Carlo Romagnano (11/3/2009)
Noel McKinney (11/3/2009)
This is the main reason I make it a habit to use COALESCE rather than ISNULL unless there's a reason I need the behavior of ISNULL.
I...
November 3, 2009 at 6:36 am
hawaiianrebel (10/16/2009)
I was a knuckle head and missed the "English only" so yes varchar or char. The choice between the ...
October 16, 2009 at 3:09 pm
Toreador (10/16/2009)
The explanation describes which uses least space, which is not the same thing as most efficient.
I suspect that the answer is correct, but...
October 16, 2009 at 6:18 am
hakan.winther (10/16/2009)
Hugo Kornelis (10/16/2009)
October 16, 2009 at 5:13 am
Damian Widera-396333 (10/16/2009)
in terms of I/O we could assume fixed length data types are better than varying ones.
If, and only if,
a) the average length of data is only 2 characters...
October 16, 2009 at 3:43 am
Viewing 15 posts - 2,956 through 2,970 (of 3,348 total)