After dropping a column with sensitive data from a SQL Server table, the data still exists on the data and index pages. To ensure the protection of this data, it needs to be removed from the pages as well.
For SQL Server (in particular, SQL Server 2012), what is an effective and efficient way to remove all of the data from the actual pages?
If the solution causes data to be moved to new/recycled pages, do the all the original pages get overwritten? For pages that are recycled for rebuilding, this would obviously be the case. For pages that were part of the table/indexes will they be wiped or have the sensitive data removed in some other manner?