Temporal Tables

Temporal Tables are useful in scenarios that require tracking of data changes in a database environment

Use cases for temporal tables include any of the following scenarios:

Data audit

Use temporal system-versioning on tables that store critical information for which you need to keep track of what has changed and when, and to perform data forensics at any point in time.

Point-in-time analysis (time travel)

Unlike a data audit, where the focus is typically on changes that occurred to individual records, in time travel scenarios users want to see how entire data sets changed over time.

Anomaly detection

Anomaly detection is the identification of items that do not conform to an expected pattern or other items in a dataset.

Slowly-changing dimensions

Dimensions in data warehousing typically contain relatively static data about entities such as geographical locations, customers, or products.

Repairing row-level data corruption

You can rely on historical data in system-versioned temporal tables to quickly repair individual rows to any of the previously captured states.

For more information, go to Temporal Tables - SQL Server