Press "Enter" to skip to content

Temporal Tables In SQL Server 2016

Randolph West has a preview of temporal tables in SQL Server 2016:

Temporal tables allow us to retrieve the state of a table, at a specific point in time, using a method called effective dating. Not only useful for auditing and forensics, temporal tables can help if data is accidentally deleted, or perform trend analysis in a simpler way.

I’m hoping there’s an entry on the potential performance impacts.