SQL Server Temporal Tables Advanced Query Strategies In parts one and two of this series we learned how to create or convert a temporal table and basics on how to query history. Once you start using temporal tables it doesn’t take long before you are pushing the...
Converting an Existing SQL Server Temporal Table In my previous article on SQL Server Temporal Tables I showed how to create a Temporal Table in a SQL Server database and do time-based querying but what if you have an existing table loaded with data? Sure, creating a...
Introduction to SQL Server Temporal Tables On a recent project we needed to add the ability to track the history of changes to user records in an application. This application was already in maintenance mode, so we also wanted to minimize the number of code changes to...
