In my last article - Identify Tables With Dropped Columns - we saw how we can identify tables that have columns that were dropped. Today, we are going to check a way to approximately calculate how much space we can expect to recover if we rebuild our table. If you want to read the 1st article I published on this subject, you can read it here - What happens when we drop a column on a SQL Server table?

Continue reading

On my last article - What happens when we drop a column on a SQL Server table? Where’s my space? - I have shown what happens when we drop a column from a table. Today, we are going to check if we have a way to find tables with dropped columns. Why? As we learnt, when we drop a column this is just a metadata operation and won’t clear the space that was being used.

Continue reading

This article was initially posted on SQLServerCentral @ 2024-04-26. Short answer: The column is marked as ‘deleted’ and will stop being visible/usable. But, most importantly - The record/table size will remain unchanged. A metadata operation Dropping a column is a metadata/logical operation, not a physical one. This means that the data isn’t removed/overwritten by this action. If we were talking about deleting data (records), as Paul Randal mentions here :

Continue reading