Temporal Tables

In this tip we look at what temporal tables are in SQL Server and how to use temporal tables.

In this tip we look at the benefits of using Temporal Tables with Memory Optimized Tables and things you should know when combining these two SQL Server features.

In this tip, we look at some additional benefits of temporal tables like schema changes being propagated to history tables, compression and indexing.

In this tip we look at some of the benefits and uses of SQL Server temporal tables.

In this tip we look at the benefits of using SQL Server Temporal tables for quick recovery of deleted data or accidental data updates.

In this tip we look at how to query SQL Server temporal tables and history tables using FOR SYSTEM_TIME including AS OF, ALL, FROM, BETWEEN and CONTAINED IN.

Find out more about SQL Server Temporal Table MetaData with sys.tables, OBJECTPROPERTY(), sys.periods and sys.columns.

In this tip we learn about cascading updates and deletes when using temporal tables in SQL Server.

Learn about the options and new opportunities for Temporal table history retention in SQL Server 2017.

In this tip we look at how to figure out who changed what data when using SQL Server 2016 temporal tables.

SQL Server 2016 introduced a new feature, Temporal Tables, which allow you to keep a historical record of all of the versions of each row in a table. As rows get introduced, changed, and deleted over time, you can always see what the table looked like dur

Learn about the new FROM clauses in the SQL Server 2016 to support temporal tables including the FOR SYSTEM_TIME clause, AS OF, BETWEEN, CONTAINED IN and more.

Temporal tables is a new feature introduced with SQL Server 2016 and allow automatic history tracking of data in a table.