In this article I’ll cover all aspects of a new SQL Server 2016 feature, Temporal Tables (System-Versioned), including:

  • Introduction
  • What is a temporal table?
  • Why Temporal table?
  • How does temporal table work?
  • Consideration and limitation
  • Temporal tables vs CDC
  • Creation and configuration
  • Clean up and removal
  • References

Introduction

AS we know, Microsoft released SQL Server 2016 RTM version (13.00.1601.5) and in November of 2016 updated it by the latest CU (Security Bulletin MS16-136 (CU) KB #3194717) (13.0.2186.0) you can check this update from here.

 

To complete the post please check it over SQLShack

 

Published by Mustafa EL-Masry

MY NAME IS MUSTAFA ELMASRY I have total years’ Experience +10 in SQL Server technology started my carrier path in 2008 as technical Support and now I am working as a Database Consultant in the banking sector managing around 200 DB Servers AS Production servers plus other environments UAT, SIT and staging servers, I have High-level experience in Database Administration, Performance Tuning, disaster recovery, development (T-SQL), SSRS. And Good Experiences in SSIS, SSAS AZURE DB, Automation (Power-Shell + TSQL) I will be Happy if you take a look on my main profile to know more information about me and to know how you can contact me (https://mostafaelmasry.com/about-me/)

Home, SQL Server 2016

,

Leave a Reply

Fill in your details below or click an icon to log in:

Gravatar
WordPress.com Logo

You are commenting using your WordPress.com account. ( Log Out /  Change )

Google photo

You are commenting using your Google account. ( Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. ( Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. ( Log Out /  Change )

Cancel

Connecting to %s

Blog at WordPress.com.

Up ↑

%d bloggers like this: