Re: Reclaiming diskspace after deleting rows
- From: "Bob Barrows [MVP]" <reb01501@xxxxxxxxxxxxxxx>
- Date: Wed, 18 Oct 2006 14:05:17 -0400
Steve B wrote:
I deleted about 20 million rows out of my DB that had about 200
million rows. I expected that I would regain diskspace when showing
the properties of that drive, but the disk was not reclaimed. Do I
need to shrink that DB in order to see how much actual space has been
reclaimed, or do I need to do something else?
And any idea how long it would take to do the shring?
What is the DB? Why wouldn't you think that information would be
relevant?
--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.
.
- Prev by Date: Re: SQL Update with Subselect
- Next by Date: Re: Reclaiming diskspace after deleting rows
- Previous by thread: Re: Reclaiming diskspace after deleting rows
- Next by thread: Re: Reclaiming diskspace after deleting rows
- Index(es):
Relevant Pages
|
|
