Wednesday, March 28, 2012

How can i reclaim the unused space of table ?

use "sp_spaceused" find one table have so many unused space,
i want to reclaim the unused space , How do ?
"DBCC UPDATEUSAGE " cann't do it, can you help me?DBCC SHRINKFILE ,for more details please refer to the BOL
"'" <@.discussions.microsoft.com> wrote in message
news:D965FA0D-92D7-4272-8907-31072261FF13@.microsoft.com...
> use "sp_spaceused" find one table have so many unused space,
> i want to reclaim the unused space , How do ?
> "DBCC UPDATEUSAGE " cann't do it, can you help me?|||That is not work ! i'm so desponded !|||any way else ? help ! please ! That is too difficulty !|||http://www.devx.com/tips/Tip/21762
"'" <@.discussions.microsoft.com> wrote in message
news:3101E153-160E-41A3-9AE9-75DB1CD70E51@.microsoft.com...
> That is not work ! i'm so desponded !|||i try do it, but not work . i thought the table was error, but uesed by "DBCC
CHECKTABLE" had not found error. please help me !
â'Uri Dimantâ'ç¼?å'ï¼?
> http://www.devx.com/tips/Tip/21762
>
>
>
> "'" <@.discussions.microsoft.com> wrote in message
> news:3101E153-160E-41A3-9AE9-75DB1CD70E51@.microsoft.com...
> >
> > That is not work ! i'm so desponded !
>
>|||If possible
backup , drop and recreate the table.
"è?«å­?" wrote:
> any way else ? help ! please ! That is too difficulty !|||Hello
A little hard to tell exactly what you are after. It could be you think you
have some fragmentation on a table.
Try running DBCC SHOWCONTIG against the table. As a rough guide if your scan
density is low and your scan fragmentation is high you should rebuild your
table. The easiest way to do this is to rebuild the clustered index on the
table. If the table does not have a clustered index, you can create one and
then drop it.
If that is your problem it may be worth creating a job to do this on a
regular basis.
See BOL for more details.
Hope this helps
John
"è?«å­?" wrote:
> i try do it, but not work . i thought the table was error, but uesed by "DBCC
> CHECKTABLE" had not found error. please help me !
>
> â'Uri Dimantâ'ç¼?å'ï¼?
> > http://www.devx.com/tips/Tip/21762
> >
> >
> >
> >
> >
> >
> > "'" <@.discussions.microsoft.com> wrote in message
> > news:3101E153-160E-41A3-9AE9-75DB1CD70E51@.microsoft.com...
> > >
> > > That is not work ! i'm so desponded !
> >
> >
> >|||Thanks a lot ! i had resolved it . first, truncate table ,the next,transmit
data by DTS . i had took so many times because the table has a lot of
records. why not give me a command to reclaim unused table space by sql
server 2000 ? the other database have , example , sybase, oracle..

No comments:

Post a Comment