Cleanup historical data in Temporal table using Retention Policy - SQLRelease
In this post, we will discuss how we can enable retention policy on a temporal table which can help us to clean up the older data from the history table of the temporal table. Removing the historical data from the history table is not an easy task. However, with the help of a configuration available with a temporal table named “HISTORY_RETENTION_PERIOD“, we can easily enable the cleanup process without writing any complex process.
https://www.dhirubhai.net/feed/update/urn:li:activity:6802838293529686016
#sqlserver #mssqlserver #mssql #temporal #sqlrelease