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

Implementing HA on MSSQL Server (AlwaysOn Availability group)in an on-premise environment (Part 1)

By

I am very passionate about having a disaster recovery architecture, plan and strategy. This...

I Presented with Live Captioning and Sign Language Interpreters

By

I had the pleasure of presenting a full-day pre-conference session on the Friday before...

What's New in SQL 2019? at the Santa Fe SQL Server User Group

By

Hi Santa Fe! My first remote presentation for the Santa Fe SQL Server UG...

Read the latest Blogs

Forums

tempdb shrinking

By vsamantha35

Hi, Need some quick help here. I am unable to shrink tempdb files. There...

Query to fetch quarter & year from date

By VSSGeorge

Hi, I am having the following query to fetch day & year of a...

Convert column values into single row comma separator

By Rock

Team My requirement is to convert column values into single row comma separator along...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers

Question of the Day

DBCC Meaning

See possible answers