Question : I have a question regarding the under the hood parts of the History Table in the Temporal Tables […]
Tag: temporal-tables
Using SQL Server’s 2016 Temporal Tables to Record Prior History
Question : I’ve been reading with interest about SQL Server 2016’s Temporal Table capability. It almost seems like the answer […]
Add a column at a specific position in system versioned temporal table
Question : I need to add a column to a temporal table. The Microsoft documentation only suggests appending the new […]
SQL Server: Time Series Table Design
Question : I am creating a time series database that follows the table structure here: Storing intervals of time with […]
How can I suppress or disable temporal table history insertion for a single statement or transaction?
Question : I have a table that stores Customer information (your bog-standard CRM stuff): CREATE TABLE dbo.Customers ( TenantId int […]
Interpreting Decision Time (DT) in temporal databases
Question : Could anyone give me an insight for the need to model decision time in temporal databases and specifically […]
how to add a query to postgres and have it show up as a table
Question : I’m not sure what technology I need because I’m not a DBA, but I’m sure there’s a good […]
Should ‘FOR system_time ALL’ include rows where the start and end times are equal?
Question : Querying a system-versioned temporal table with FOR system_time ALL appears to omit rows where the start and end […]
SQL Server 2016: Adding temporal tables to existing application
Question : I have a big PHP application, developed by an external company, which is being completed right now; I […]
Are SQL Server’s temporal tables here to stay?
Question : We’re considering different approaches to save records’ history in an application. Some of the managers in charge are […]