Jeff Moden (7/14/2011)

---

IMHO, Method #2 is definitely the better way go for a lot of the reasons you stated. It's called a "Type 2 Slowly Changing Dimension".

When I do...

GilaMonster (5/5/2011)

---

Long running transaction that it needs to roll back?

With Rollback Immediate it will start the roll back immediately. Has to finish it, if there's a long-running, large transaction...