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--
Subscribe to:
Post Comments (Atom)
 
No comments:
Post a Comment