David Ziffer (10/21/2012)
Everything has its price. The flip side: I have never seen any other application(s) anywhere, other than ones written by me using this system, that are capable of returning you (via the app's ordinary user interface) to any desired moment in the past.
Gosh... TYPE 2 SCDs are used for such a thing all the time. The only difference between what they do and what you're suggesting is that you store the whole rows in a separate table rather than in the original table. The EAV solution is also capable of doing such a thing albeit with a bit more effort.
--Jeff Moden
Change is inevitable... Change for the better is not.