As we mentioned in Change Tracking – What is this and how it works, the retention period is the one that determines how long the changes are kept.
Performance
4 posts
Change tracking was introduced in SQL Server 2008. This is a tool that keeps the fact that there are changes in tracked tables for a specified period of time. It doesn’t show what the changes are, it tells that a data has been changed. It answers if a change has been […]
There is a great news today for SQL Server community – SQL Sentry (RSS: SQLPerformance.COM) Plan Explorer is FREE for everyone. Download User Guide Thank you, SQL Sentry! Keep it simple :-)