• Having just skimmed over this posting, I'm not sure that this is relevant, but have you looked at the "quirky update" method. Yes, it's a bit dirty, but if you must have performance, then it's worth trying.

    See: Solving the Running Total and Ordinal Rank Problems: http://www.sqlservercentral.com/articles/T-SQL/68467