Skip to main content
Database Administrators

Return to Question

added 118 characters in body
Source Link
Uma
Uma
  • 11
  • 3

I have a database which is 20 GB and it has history information since year 2001. Now I started deleting data prior to year 2008. after completion of deletion how can i reuse the space that is cleared by my delete statement. I am using SQL Server 2005.

Will Sql server automatically reuse the space if I don't shrink the datafiles? Should we rebuild the indexes?

I have a database which is 20 GB and it has history information since year 2001. Now I started deleting data prior to year 2008. after completion of deletion how can i reuse the space that is cleared by my delete statement. I am using SQL Server 2005.

I have a database which is 20 GB and it has history information since year 2001. Now I started deleting data prior to year 2008. after completion of deletion how can i reuse the space that is cleared by my delete statement. I am using SQL Server 2005.

Will Sql server automatically reuse the space if I don't shrink the datafiles? Should we rebuild the indexes?

Post Closed as "Duplicate" by RLF, RolandoMySQLDBA, Mark Storey-Smith, user507, Paul White♦
Source Link
Uma
Uma
  • 11
  • 3

reusing space after deleting lots of rows

I have a database which is 20 GB and it has history information since year 2001. Now I started deleting data prior to year 2008. after completion of deletion how can i reuse the space that is cleared by my delete statement. I am using SQL Server 2005.