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...

anil.kubireddi (12/2/2009)

---

i am refferning to the below question posted,

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...

bitbucket-25253 (11/19/2009)

---

Having recently gotten my brains beat out, my integrity questioned, my intelligence derided and other wise vilified (Refer to the QOD 11/17/2009 forum). I am greatly surprised...

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...

Jeff Moden (11/10/2009)

---

You have to observe all the rules at once, Hugo. I said in the rules that you can't use a JOIN in conjunction with the "Quirky Update"...

Jeff Moden (11/10/2009)

---

Heh... very cool optimization of the cursor, Hugo. You've managed to upgrade it to only...

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...

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...

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...

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...

Carlo Romagnano (11/3/2009)

---

I...

hawaiianrebel (10/16/2009)

---

See I got it wrong for two reasons:

I was a knuckle head and missed the "English only" so yes varchar or char. The choice between the ...

Toreador (10/16/2009)

---

The question asks which is more efficient.

The explanation describes which uses least space, which is not the same thing as most efficient.

I suspect that the answer is correct, but...

hakan.winther (10/16/2009)

---

Hugo Kornelis (10/16/2009)

---

That's reallly a shame, as the only good reasons to use varchar instead of char are a difference of more than 2 between average and maximum length;...

If, and only if,

a) the average length of data is only 2 characters...