Set temporal table retention, check history cleanup settings, and choose a history index that lets old versions leave safely.
Special Icon on System-Versioned Table in SQL Server 2016 – Interview Question of the Week #101
Expanding tables in WideWorldImporters in SSMS 2016, you see an icon like a watch. It marks a System-Versioned table, also known as a temporal table.
Who Changed This Row? Temporal History With FOR SYSTEM_TIME ALL
Read FOR SYSTEM_TIME ALL with LAG to compare row versions, choose temporal window boundaries, and record an actor when identity matters.
SQL SERVER 2016: Creating Simple Temporal Table
Want to see what your data looked like on a past date? Here is how to create a simple Temporal Table in SQL Server 2016, with its history table made for you.
Who Changed This Row? Auditing Data Changes
Auditing data changes requires choosing whether you need old values, new values, actor identity, or a change feed, then testing the cost.
Adding System Versioning to a Table That Already Has Rows
Turning on temporal history for a table that already has data does not rebuild the past. Here is the clean way to do it, and the traps to avoid.
Joining Two History Tables at a Point in Time With FOR SYSTEM_TIME AS OF
Use FOR SYSTEM_TIME AS OF to join temporal tables at one UTC instant, compare range forms, and index the history lookup correctly.