Post reply

What happens when we drop a column on a SQL Server table? Where's my space?

  • April 26, 2024 at 8:15 pm

    #4415932

    Thank you. I enjoyed the article very much.

  • April 28, 2024 at 10:02 pm

    #4416435

    Presumably, future inserts (after the column is dropped) won't consume use space for the deleted column, though?

    Also, question, if a page is rewritten (e.g., due to a normal insert or update), is the space taken by a deleted column recycled then?

  • August 1, 2024 at 4:06 pm

    #4397523

    Comments posted to this topic are about the item What happens when we drop a column on a SQL Server table? Where's my space?

  • October 15, 2024 at 7:44 pm

    #4468897

    If we remove all the rows that contained the columns that was dropped, while adding new rows that dont use the dropped column, will the space eventually be reclaimed?

    For example, we have 100 rows.

    Drop the column

    Add 50 rows

    Delete the first 100

    Add another 100, etc...

  • October 15, 2024 at 7:52 pm

    #4468898

    Same question as Grasshopper. If we remove all the rows that contained the columns that was dropped, while adding new rows that dont use the dropped column, will the space eventually be reclaimed?

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply