Carla Wilson (1/31/2008)

---

Jeff,

Thanks for the great examples on generating running totals. Question: You mentioned that you have to include the "anchor" (or dummy) in the update statement in...

Christian Buettner (2/1/2008)

---

Yet I am not convinced, even if you show me a thousand times that your code works. What I really would like to see is some documentation from...

Thanks for the code, Johan... I'll check it out! And thanks for taking...

Matt Miller (1/30/2008)

---

Well - now that you have SQL server doing your file maintenance - any chance you can figure out how it can turn the coffee on in...

I've gotta agree with that!

Darrin Blunt (1/31/2008)

---

Since you installed SQL 2K5, have you looked into the "OVER" clause (BOL reference: ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/tsqlref9/html/ddcef3a6-0341-43e0-ae73-630484b7b398.htm) and the Ranking Functions (BOL reference: ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/tsqlref9/html/e7f917ba-bf4a-4fe0-b342-a91bcf88a71b.htm)?

I am curious how...

RichardB (1/31/2008)

---

Pure Awesomeness!

Run over 1.4million records on a 6 level 'hierarchy' in about 10 s - compared to the 'set' solution that takes 1.5hrs...

:exclamationmark:

Oh yes, and validation against the...

Philippe Cand (1/31/2008)

---

I will derail this conversation and give it another spin.

Wether or not something is supported by Microsoft does not make it safer.

It is all about probability and bugs....

James Goodwin (1/31/2008)

---

Did you test using the Clustered Index with the ORDER BY subquery? It seems to me that the ORDER BY Would enforce the order, but since you...

However, the engine has no obligation to scan the table in index order, as there are no language constructs which impose an ordering on the execution order of a scan....

Ian Yates (1/31/2008)

---

I have to agree with the naysayers unfortunately. It's great at the moment and really does seem to work (I haven't seen it fail yet either). ...

ALZDBA (1/31/2008)

---

Very good article, nice testcode. :w00t::cool:

There may be some testing needed regarding parallelism,

maybe for now just add a OPTION(MAXDOP 1).

The only remarks I would add to the conclusion...

Christian Buettner (1/31/2008)

---

Hello Jeff,

very interesting article.

Somehow it throws all my beliefs into the trash bin:

1. The update method with variables is not explicitly supported by Microsoft

2. The clustered...

According to a recent radio ad by one of the better known railways, freight trains use only 1 gallon of fuel to haul 1 ton (2,000 pounds) 443 miles... we...

Yep... thanks for the feedback. I've seen that, too. But only on SELECTs... and only on non-clustered indexes. I've never seen it fail on UPDATEs on CLUSTERED...