My Five Year Payment History Since FSB

Hey everyone. It's been a long while since I've been active here on the forums. I started with FSB in October 2012. I thought it would be interesting for some of you if I posted my entire 5 year payment history since then. It's far from amazing but I think demonstrates the value of FSB.

I spent a few months in the beginning focused on my sites and then got involved in other things and spent less and less time on them as months passed. Eventually I spent ZERO time on these sites and they…

My Five Year Payment History Since FSB

History table implementation: “Tuple-versioning” vs Effective Date

I’m designing a database that will have history tables (SCD Type 4 I guess) for auditing purpose.

The question is what are the advantages of having tuple-versioning (start and end dates) vs just effective date?

1) tuple versioning

CREATE TABLE HistoryTable (    Column1   Type1,       :        :    Columnn   Typen,     StartDate DATETIME,    EndDate   DATETIME ) 

2) effective date

CREATE TABLE HistoryTable (    Column1   Type1,       :        :    Columnn   Typen,     EffectiveDate DATETIME ) 

For (1) so far I see disadvantages – I have to update [end date] on the previous history record while inserting new/current one.

For (2) I can only insert new record without searching and modification the previous one.

From query point of view both approaches look quite the same.