2016 SQL Server Temporal Databases
Posted: May 16, 2015 Filed under: Microsoft SQL Server, Microsoft SQL Server 2016 | Tags: Microsoft SQL Server, Microsoft SQL Server 2016 Leave a commentData 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