SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

BiTemporal Tables, anyone?

I'm doing some interesting research on using BiTemporal tables and I was wondering if anyone out there has any real-world experience using these. Basically these are tables where you have effective dates and audit dates in the same table. You may know these by other names, such as 'Valid Time States" (Effective Dates) and "Transaction Time States" (Audit dates). These are complicated but quite promising...does anyone have any real-world feedback on using these?


No comments.

Leave a Comment

Please register or log in to leave a comment.