Temporal Tables

SQL Server Temporal Tables: How-To Recipes

  • Article

Tables that return the value of the data in the table at a particular point of time have been with us since the first relational database, but have always required special queries and constraints, and can be tricky to get right. System-versioned Temporal Tables, new in SQL Server 2016, make such tables behave like any other. How do you create one, or modify an existing table? How can you get an In-Memory Optimized OLTP table to be Temporal? Alex Grinberg shows how.


3,726 reads

Getting Started with Temporal Table in SQL Server 2016 – Part 1

  • Article

With the new temporal table feature, SQL Server 2016 internally manages two tables: a base table, which contains the latest data all the time, and a history table, which contains a history of all of the changes. Arshad Ali looks at the new feature, how it works, and how to either create a new table with this feature or enable it for an existing table.


4,139 reads




Hey Command: A confident name that suggests a laid-back approach to leadership. ...



Threat Key: A strong name that suggests competent security solutions. ...



Growing Fortune: A memorable name that is bursting with ambition and opportunity. ...

Read the latest Blogs


Updating Two Values from a Temp table

By smthembu

I have a source table from Oracle db that needs to Update a SQL...

Placing Data files on NAS

By tmmutsetse

Hi experts, Is it ok to run a Production DB with data files and...

SQL Server Backup and Restore Ebook error

By as1981

When I fill in the form here https://www.red-gate.com/library/sql-server-backup-and-restore?utm_source=ssc&utm_medium=publink&utm_campaign=books&utm_content=backup_and_restore_ebook&utm_term=backupandrestore and click 'download ebook' the button...

Visit the forum


SQL Server Q&A from the SQLServerCentral community

Get answers