Temporal Tables FAQ
I had the pleasure of presenting Temporal Tables to the Capital Area .NET User Group on December 10, 2024. Some interesting FAQ arose from that meeting so I thought it would be good to share it on my blog for reference. Is the historical table logged to the Transaction log in the same way a conventional table is? Will we “see” the inserts in the Tran log the same way we see them for a normal table? No Are Temporal Tables available in Azure? Yes, in Azure SQL Database and Azure SQL Managed Instance Will Temporal Tables work with graph tables? No, Node and edge tables can't be created as system-versioned temporal tables Ref: https://learn.microsoft.com/en-us/sql/relational-databases/graphs/sql-graph-architecture?view=sql-server-ver16 What triggers the purge of SQL Server Temporal Tables? A background task is created to perform aged data cleanup for all temporal tables with finite retention period...