A temporal table is table that holds old versions of rows
within a base table. By having temporal tables SQL Server can automatically manage
moving old row versions to the temporal table every time a row in the base
table is updated. The temporal table is physically a different table than the
base table, but is linked to the base table. If you’ve been building or plan
to build your own method to managing row versioning then you might want to
check out the new temporal tables support in SQL server 2016 before you go
forth and build your own row versioning solution.
Where You Can Get Additional Information
Below are some additional resources that you
can use to find out more information about SQL Server 2016.
SQL Server 2016 data sheet: http://download.microsoft.com/download/F/D/3/FD33C34D-3B65-4DA9-8A9F-0B456656DE3B/SQL_Server_2016_datasheet.pdf
SQL Server 2016 release notes: https://msdn.microsoft.com/en-US/library/dn876712.aspx
What’s new in SQL Server, September Update: https://msdn.microsoft.com/en-US/library/bb500435.aspx
SQL Server 2016 has many new features. Some
of features are enhancements to existing features, while others are entirely
new features. In this article I only explored some of the new functionality
in SQL Server 2016. When moving to SQL Server 2016 you should exploit those
new features that provide value to your SQL Server environment.
See all articles by Greg Larsen