2016 SQL Server Temporal DatabasesPosted: May 16, 2015
Data growing, lot of modifications, not all are correct.
Time Travel – go back in time
Repair db corruptions!
Setup Audit on a Table or object and action (insert,update,deleted)
Alter table with period definition
GENERATED ALWAYS AS ROW START
PERIOD FOR SYSTEM TIME – just like DB2
Alter table with history table
Valid from and Valid To