December 2016 - Tomas Lind

Microsoft SQL Server

Identity columns that are about to overflow

Post author:Tomas Lind
Post published:2016/12/08
Post category:T-SQL Tips & Tricks
Post comments:0 Comments

Identity columns are widely used as primary key columns in SQL Server tables. They can be one of the data types TINYINT, SMALLINT, INT, BIGINT, NUMERIC or DECIMAL. Each of these data types has an upper limit and when that upper limit is reached, an error is raised and further inserts into the table are impossible.

(more…)

Microsoft SQL Server

Temporal Tables Introduction

Post author:Tomas Lind
Post published:2016/12/06
Post category:Temporal Tables
Post comments:0 Comments

Temporal tables was introduced in SQL Server 2016, and is a technique that simplifies keeping track of changed records in a table. The handling of changes of records in a data warehouse dimension table is a good example of when temporal tables can be useful. In this blog post, I’ll cover the basics of temporal tables.

(more…)