Without the execution plan, 12 seconds for quirky with MAXDOP 1, 151 for the RCTE. I ran them...

Taking this one step further, if anyone wants to supply the script for a CLR function(and possibly explain to me how to use it) or any other alternate method they...

And the results are in. It probably wasn't a fair contest to begin with. You were going up against a gut accustomed to eating 2 day old Taco...

Dave Ballantyne (9/18/2009)

---

Your wish is my command 🙂

Happy to be proved wrong , evidence either way is good in my book.

You just need to manually update the acct value ,

and...

Dave Ballantyne (9/18/2009)

---

Also, with the quirk update , although you have specified index(0) are the rows guaranteed to come back in the required order ? . If you joined...

First, a disclaimer.

This is most likely not the best method for this. There may be an exporting service like SSIS or one of those that can handle this much...

My gut feeling is that you're wrong :-D. But that's what we...

BOL[

---

timestamp

timestamp is a data type that exposes automatically generated binary numbers, which are guaranteed to be unique within a database. timestamp is used typically as a mechanism for version-stamping...

Does your table have another field that is actually related to the date of the records? Despite its' name, a timestamp field has nothing to do with time and...

Jeff Moden (9/17/2009)

---

Garadin (9/17/2009)

---

It's ok. Everybody forgets the index :-P.

I'm still looking for another way to do iterative logic that can compare with this method. I've heard CLR...

Jeff Moden (9/17/2009)

---

Seth,

I haven't executed your good code but it looks right. My only suggestion would be to add OPTION (MAXDOP 1) to the update to prevent any parallelism...

Greg Snidow (9/17/2009)

---

Ok, this might be a dumb question, but if I specify the physical order of the records on the insert, then why is the index so vital? ...

It's ok. Everybody forgets the index :-P.

I'm still looking for another way to do iterative logic that can compare with this method. I've heard CLR functions can beat...

The article is under construction atm, but I've prettymuch got it memorized :hehe:. The whole theory...

So, you're claiming the following?

You have an offsite SQL2000 DB (Central) with a table containing 300 records

You have an onsite SQL2005 DB.

You are attempting to use this SQL2005 DB to...