May 30, 2005 at 10:15 pm
Hi all,
What exactly happens when we delete rows in a table ? Does sqlserver reclaims as and when the delete is committed ?
NSR
May 31, 2005 at 1:13 am
Hi,
This may help you..
http://www.mssqlcity.com/Articles/SQL65/PageStr/SQL65PageStr.htm
This is for SQL Server 6.4. I think this should be the same for the later versions. Let us know if you find anything for 2000 or 2005
May 31, 2005 at 1:52 am
In terms of internal file space I've found that deleting records from an indexed table does not automatically reclaim space.
Running a DBCC DBREINDEX does that, similarly dropping and recreating indexes does as well. I can't comment on defragging because I haven't done it.
May 31, 2005 at 2:15 am
Piggy-backing on Dave, SQL Server doesn't not automatically reclaim space unless this space is needed for inserting a new row.
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply