{"id":848,"date":"2015-07-23T10:30:06","date_gmt":"2015-07-23T09:30:06","guid":{"rendered":"http:\/\/dotnetsql.info\/net-sql\/?p=848"},"modified":"2015-08-13T12:17:02","modified_gmt":"2015-08-13T11:17:02","slug":"sql-server-interview-question-data-deletion-size-reduction","status":"publish","type":"post","link":"http:\/\/dotnetsql.info\/net-sql\/index.php\/sql-server-interview-question-data-deletion-size-reduction\/","title":{"rendered":"Sql Server Interview question: Data deletion \/ Size reduction"},"content":{"rendered":"

Question<\/strong>: When you delete data from a table, is SQL Server reducing immediately the size of that table?<\/p>\n

Answer<\/strong>:No,\u00a0When data is deleted from any table, SQL Server does not reduce the size of the table right away.<\/p>\n

It marks those pages as free pages, showing that they belong to the table. When new data is inserted, they are put into those free pages first.<\/p>\n

Once those pages are filled up, SQL Server will allocate new pages. If you wait for some time, the background process de-allocates the pages, finally reducing the page size.<\/p>\n

Thanks \u00a0for reading \u00a0this \u00a0article,<\/strong><\/p>\n

Next steps :<\/strong><\/p>\n

1.\u00a0 Share this with your colleagues because Sharing\u00a0 is Learning<\/strong><\/p>\n

\u00a0 \u00a0 \u00a0 \u00a0 2. Comment below if you need any assistance<\/strong><\/p>\n

Powered by CodeReview – Let’s make it Better!<\/a><\/strong><\/em><\/p>\n

Share this:<\/h3>