Question : I have: table with existing data SQL Server 2016 SP1 SQL Server Management Studio 17.5 I am using […]
Tag: temporal-tables
Schema binding seems to not be enforced for view doing temporal query
Question : I am using Microsoft SQL Server 2019. There are two strange behaviors that I don’t see documented (if […]
Combine various temporal criteria to filter rows
Question : I am trying to query a database table with some filters. I have a form through which a […]
SQL Server Temporal Tables History Table size
Question : I have a question regarding the under the hood parts of the History Table in the 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 […]