xsevensinzx (10/6/2015)
Interesting stuff.I have to ask though, why not just manually make this yourself with 2 tables and some triggers? All it's doing is tracking the history of the table into another table and adding additional syntax to go back into time to see the results of your data say, 6 months ago?
Agreed, I've created many systems where we had to manually create the tables and triggers to maintain history. But, now, with a temporal table, the question is: Why do it manually?
It's now just a quick change to the table. And you can add it to existing tables via the ALTER statement.
As to any storage questions, that is a function of if and why you need to track history from a business standpoint. Once you decided you do need history, than now you have two options: Temporal, or the manual approach.
Also, this is very different from CDC (change data capture).
The more you are prepared, the less you need it.