Question : I am creating a time series database that follows the table structure here: Storing intervals of time with […]
Tag: temporal-tables
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 […]
Temporal Table: Multiple inserts on each update?
Question : Actual Question: Is there anything in sql 2019 server (besides a trigger) that can cause multiple rows to […]
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 […]
MS SQL temporal tables not properly
Question : I have an existing table and wanted to create temporal tables. I used following queries, it worked in […]