Tuesday, February 14, 2012

Delete OF 2.5 GB (Cont.)

Hi,
Thanks for your earlyer comments, but now i have a problem:
1. I have backed up the database
2. i've made 2.5 GB deletes in small batches
3. This table only has a clustered index on an PK Column,
i have performed a DBREINDEX on that Pk clustered index.
Results:
name
Table_name
rows reserved data index_size unused
221392 4902000 KB 2724296 KB 112 KB 2177592 KB
How can i free the unused table space '? Why the
dbreindex didin't release this space '
Sorry :) Can you help me ?
Thanks again
Mike
.This is a multi-part message in MIME format.
--=_NextPart_000_001B_01C443E6.38002850
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Try running DBCC SHRINKDATABASE. The rebuild of the clustered indexed =will not release space back to the operating system.
Thanks,
Ryan Stonecipher
Microsoft SQL Server Storage Engine
"Mike" <anonymous@.discussions.microsoft.com> wrote in message =news:1372d01c44405$612fbbe0$a601280a@.phx.gbl...
Hi,
Thanks for your earlyer comments, but now i have a problem:
1. I have backed up the database
2. i've made 2.5 GB deletes in small batches
3. This table only has a clustered index on an PK Column, i have performed a DBREINDEX on that Pk clustered index.
Results:
name Table_name rows reserved data index_size unused 221392 4902000 KB 2724296 KB 112 KB 2177592 KB
How can i free the unused table space '? Why the dbreindex didin't release this space '
Sorry :) Can you help me ?
Thanks again
Mike
.
--=_NextPart_000_001B_01C443E6.38002850
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&

Try running DBCC SHRINKDATABASE. The rebuild =of the clustered indexed will not release space back to the operating =system.
Thanks,
Ryan Stonecipher
Microsoft SQL Server Storage Engine
"Mike" wrote in message news:1372d01c44405$=612fbbe0$a601280a@.phx.gbl...Hi,Thanks for your earlyer comments, but now i have a problem:1. I have =backed up the database2. i've made 2.5 GB deletes in small batches3. =This table only has a clustered index on an PK Column, i have performed a =DBREINDEX on that Pk clustered =index.Results:name &=nbsp; &n=bsp; &nb=sp; &nbs=p; =Table_name  =; = &=nbsp; = &nb=sp; &nbs=p;  =; = rows reserved data index_size =unused &=nbsp; 221392 4902000 KB 2724296 KB 112 KB =2177592 KBHow can i free the unused table space '? Why the =dbreindex didin't release this space 'Sorry :) Can you help me ?Thanks =againMike.

--=_NextPart_000_001B_01C443E6.38002850--

No comments:

Post a Comment