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.

2017-05-30

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.

2016-04-11

4,139 reads

Blogs

A Memory-Optimized Roundup – T-SQL Tuesday #117

By

The summary from my fourth T-SQL Tuesday hosting for #117. This time I was...

How do you debug your spark-dotnet app in visual studio?

By

When you run an application using spark-dotnet, to launch the application you need to...

More PowerShell Remoting coverage in dbatools

By

Starting on dbatools version 1.0.31 we introduced better coverage for commands that make use...

Read the latest Blogs

Forums

Advice for a Rookie DBA

By Sopheeyah

Hello everyone! I'm new a DBA and  I was wondering if anyone could share...

Reading Part of a Dataframe

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Reading Part of a Dataframe

The First Rule

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The First Rule

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers