JAhlen (11/4/2009)

---

Hi Rob,

Thanks for your feedback! Sure you can write the closing balances calculations in much shorter ways (like your example), but performance would be severely reduced. The purpose of...

Here's a much simpler way to calculating the CloseBalance. No recursion or temp tables. A temp table for the daily total would definitely be faster especially in future dates, just...

Very cool article, I utilize precalculation all of the time, but never had to do closing balances or similar to that, but definitely great to know. The SQL to calculate...

Dean Cochrane (10/28/2009)

---

rbramhall (10/28/2009)

---

The problem is that whenever I update the product mix, I'm deleting/updating/inserting up to 2.5M rows in the 83M row table at a time. We threw lots...

ta.bu.shi.da.yu (10/28/2009)

---

rbramhall (10/28/2009)

---

I just wish there was another way that when inserting/deleting the 2.5M records in my table it wouldn't do a total table lock and at 2-3 minutes it...

Actually this brought up another issue I have always wanted to solve. I have a store/product table mapping, ~83M rows and always growing as stores are added. The stores can...

Very cool. I never knew any of this stuff and haven't seen very many articles on statistics. From the article I guess I inferred that the statistics help especially if...

Absolutely agreed.

Need to add Skill level or Complexity level to articles, so people would know this is an entry level article. Maybe a better title, like "Different types of Results for...