sql server 2016 system-versioned temporal

Описание: Real data sources are dynamic and more often than not business decisions rely on insights that analysts can get from data evolution. Use cases for temporal tables include:

Auditing all data changes and performing data forensics when necessary

Reconstructing state of the data as of any time in the past

Calculating trends over time

Maintaining a slowly changing dimension for decision support applications

Recovering from accidental data changes and application errors