After experiencing weekly CDC failures caused by transaction log issues and logs suddenly chewing up disk space, I found myself repeatedly investigating the same questions: Why is the log so large?

SUM(CASE WHEN Policy_ID IS NULL THEN 1 ELSE 0 END) AS NULL_Policy_ID, SUM(CASE WHEN Customer_Age IS NULL THEN 1 ELSE 0 END) AS NULL_Age, SUM(CASE WHEN Gender IS NULL THEN 1 ELSE 0 END) AS NULL_Gender, ...