1 Answer

answered by

When data is deleted from any table, SQL Server does not reduce the size of the table instantly; however, it marks those pages as free pages, showing that they belong to the table. When we insert new data, that data is feed into those free pages first. And once those pages are filled up, SQL Server will allocate new pages. After some time, the background process de-allocates the pages and finally reduces the page size.

0 votes
...