I found it... it's not as robust as I thought it was, but it does have several pieces of test code along with some reasons why some works better than...

Nice job, Lynn!

Like Michael said... can't be done unless you drop/recreate the table.

Updating statistics can't be done in parallel... gotta be done after all the data is loaded.

If you were in charge of a project, would you tolerate a 5-6 second lag time even on millions of rows? Rhetorical question, for sure because I know you...

Simple... Just like I said in the too short write up... I prefer the word "Tally" to "Number" 😀

Lynn... I'm thinking that one is all yours 😀

Yeah you can... insert a million rows at a time instead of all 80 million. Log won't grow but a bit on simple recovery.

If you really want some speed out of this, consider the following article (Grouped Running Total and Running Total sections), please... should be able to do 223,000 rows in about...

rbarryyoung (4/30/2008)

---

There is not that much difference between them, performance-wise.

The first one is clearly older as it uses the deprecated SET ROWCOUNT XX (this should be changed to TOP XX...

Cool! (Sorry... no pun intended). You really got around! (Dang, did it again! :D)

It's a shame they retired the Sturgeon class... good, quiet, fast platform. The...

Couple of things...

First, 'DataBase_Version' does not exist in SysObjects unless you created a table or something called 'DataBase_Version'. What is 'DataBase_Version'????

Second, look at you IF statement in the dynamic...

And you actually believe in the myth of code portability? That'll only happen when no one creates their own extensions to the ANSI standards. 😛

But, it is a Tally table... it's used to count. And, besides... as you've already found out ol' friend... Tally is not likely to ever be a reserved word....

Jason Selburg (4/30/2008)

---

Now that's funny! I used to listen to fish farts on the USS Silversides (SSN 679) & USS Jacksonville (SSN 699) back in '89.

I wonder how many...