Tim Weigel timweigel

## Modify_change_tracking.sql
ALTER DATABASE CT_Demo
SET CHANGE_TRACKING
(CHANGE_RETENTION = 14 DAYS, AUTO_CLEANUP = ON);

## Disable_change_tracking.sql
ALTER DATABASE CT_Demo
SET CHANGE_TRACKING = OFF;

## Kendra_Little_better_change_tracking_script_brent_ozar.sql
-- Kendra Little made this; posted at https://www.brentozar.com/archive/2014/06/performance-tuning-sql-server-change-tracking/
SELECT db.name AS change_tracking_db,
	is_auto_cleanup_on,
	retention_period,
	retention_period_units_desc
FROM sys.change_tracking_databases AS ct
JOIN sys.databases AS db
	ON ct.database_id=db.database_id;
GO

## Enable_change_tracking.sql
ALTER DATABASE CT_Demo
SET CHANGE_TRACKING = ON
(CHANGE_RETENTION = 30 DAYS, AUTO_CLEANUP = ON);
	ALTER DATABASE CT_Demo
	SET CHANGE_TRACKING
	(CHANGE_RETENTION = 14 DAYS, AUTO_CLEANUP = ON);
	-- Kendra Little made this; posted at https://www.brentozar.com/archive/2014/06/performance-tuning-sql-server-change-tracking/
	SELECT db.name AS change_tracking_db,
	is_auto_cleanup_on,
	retention_period,
	retention_period_units_desc
	FROM sys.change_tracking_databases AS ct
	JOIN sys.databases AS db
	ON ct.database_id=db.database_id;
	GO
	ALTER DATABASE CT_Demo
	SET CHANGE_TRACKING = ON
	(CHANGE_RETENTION = 30 DAYS, AUTO_CLEANUP = ON);