one of the great things about SQL server is the simplicity of the database architecture, particularly as compared to Oracle, do we want to go down the road of having some equivalent to redo logs? doesn't Oracle return 'snapshot too old' errors if you run out of redo log space, so there are limitations to this form of locking strategy and an imposed limit on how long a query can run for.

I am not an expert on this but I'm not sure this is a better way to handle concurrency taking the extra load to maintain the snapshot into account.