data-konzept

'Temporal data storage, which was defined in the ANSI SQL:2011 standard, describes an architecture in which relational databases maintain row-level versioned copies of data. When using temporal data, the database does automatically what many DBAs and application developers have had to do manually for years to track point-in-time versioning for individual tables. Starting in 2016, Microsoft added SQL Server temporal tables to their data platform, which moved time-based row versioning into the database engine as a native feature.

In this post, I’ll briefly introduce SQL Server temporal tables.'...

https://www.timmitchell.net/post/2017/10/11/sql-server-temporal-tables/