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
Please tell me, Who are the top villains in the history of Bollywood…?
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.