All posts by Alex Volok
SQL Server 2016: Temporal Tables. Changing the Schema
In the previous blog post, I made an introduction to the basic concepts behind temporal tables. This time I would like to cover, in a little bit more detailed way, one difficult topic – schema change: how it can be applied to temporal tables and what impact on the system it can bring. Foreword This post contains […]
SQL Server 2016: Temporal Tables. Introduction
SQL Server 2016 CTP2 finally available for the public and it brings many new features, which are worth checking. However, one of those new initiatives, I believe, can bring some discussions in DWH/BI environments. The name of it is Temporal table. Foreword It seems, the feature can bring another naming confusion. Currently SQL Server ships temporary tables and table variables. But, with […]