Change Tracking

---

T-SQL: Change Tracking Retention Period – How Long the Changes are Kept

2017-11-15  in Backend / Data Warehouse (DW) / ETL / SQL Server / T-SQL  tagged Change Tracking / Data Warehouse (DW) / DBA / ETL / Performance / SSIS / T-SQL by Peter Lalovsky

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.

---

T-SQL: Change Tracking – What is this and how it works

2017-11-14  in Data Warehouse (DW) / Database Administration (DBA) / ETL / SQL Server / T-SQL  tagged Change Tracking / Data Warehouse (DW) / DBA / Deployment / ETL / Performance / SSIS / T-SQL by Peter Lalovsky

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 […]

---

---