We’ve recently been looking at temporal tables, how they work, we query them and how to modify them. All of these are consistent since the feature was added in SQL Server 2016. There are however a couple of extra features which were added in 2017 to make these even more usable. Let’s use our previous […]
Recently we’ve been looking at temporal tables including the basics for using them and options for querying them. Continuing with this theme – and given that tables rarely remain static – we’ll look at what we might need to consider when modifying their structure. As with the previous posts we’ll start our with our sample […]
During our initial introduction we briefly saw how to query temporal tables but there were a couple of specific bits which I wanted to cover around querying these tables. The first of these concerns the point in time we query against and the second is how we go about using that point in time to […]
Last time out we took a brief look at temporal tables, how to create them and what they can do for us. This time I’d like to dive a bit deeper into them and see how they look under the covers. For this we’ll be using the same table which we ended up creating previously: […]
With the arrival of SQL Server 2016 we were provided with a new feature in the engine called System Versioned Temporal Tables – typically shortened to Temporal Tables. These tables allow us not only to query the data as it currently is, but also query it at any point in the past too as it […]
Andy Brownsword 