Free Space available for use

If I have 4 GB database with 1 GB of free space (just
completed a DELETE of records). Will the space be
available for use by INSERTS? Previously, the db was
automatically growing and I hope that stops with the mass
delete that was done. Space is running low on the drive.
Does shrinking provide a benefit?Hi Micheal,
1 GB you cleared will be used for the new data addition (Inserts).
If you run the SHRINK command it shrinks your data files (Physical files)
and since you have mentioned the auto growth option the file will grow
depends up on the amount of inserts.
Thanks
Hari
MCDBA
"Michael Orechoff" <anonymous@.discussions.microsoft.com> wrote in message
news:05e601c39da8$b18a6710$a301280a@.phx.gbl...
> If I have 4 GB database with 1 GB of free space (just
> completed a DELETE of records). Will the space be
> available for use by INSERTS? Previously, the db was
> automatically growing and I hope that stops with the mass
> delete that was done. Space is running low on the drive.
> Does shrinking provide a benefit?|||Are you saying that the db was full, and you deleted a bunch or rows so you now have 1GB free space
in db? If so,
> Will the space be
> available for use by INSERTS?
Yes.
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"Michael Orechoff" <anonymous@.discussions.microsoft.com> wrote in message
news:05e601c39da8$b18a6710$a301280a@.phx.gbl...
> If I have 4 GB database with 1 GB of free space (just
> completed a DELETE of records). Will the space be
> available for use by INSERTS? Previously, the db was
> automatically growing and I hope that stops with the mass
> delete that was done. Space is running low on the drive.
> Does shrinking provide a benefit?