Is table size reduced, when you delete data from the table?

Technology CommunityCategory: SQLIs table size reduced, when you delete data from the table?
VietMX Staff asked 3 years ago

No the table size is not reduced, indeed the sql server marks those rows as free rows. Once you insert the new data, the free rows will get updated and then the size of the table is changed based on the data insertion. If the data is not inserted, then after a while, the rows are eliminated.