SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 deleting a large number of rows
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

SQL_Gaga
Starting Member

2 Posts

Posted - 11/05/2012 :  16:45:37  Show Profile  Reply with Quote
Hi,
I deleted a large portion of the data from a table but the reserved space wasn’t released. Rebuild indexes didn’t solve the issue. Is there anything else that can be done?

Table_Name 2349797 13589152 KB 13319344 KB 144904 KB 124904 KB

When I delete all the rows (in test), there is still some reserved space.

Table_Name 0 2670648 KB 2664040 KB 88 KB 6520 KB

Microsoft SQL Server 2008 R2 (SP1) - 10.50.2806.0 (X64)

Thanks a lot!

Bustaz Kool
Flowing Fount of Yak Knowledge

USA
1754 Posts

Posted - 11/05/2012 :  17:07:11  Show Profile  Reply with Quote
Have you tried to shrink the table/file?

=================================================
We are far more concerned about the desecration of the flag than we are about the desecration of our land. -Wendell Berry

Edited by - Bustaz Kool on 11/05/2012 17:07:44
Go to Top of Page

SQL_Gaga
Starting Member

2 Posts

Posted - 11/05/2012 :  17:11:49  Show Profile  Reply with Quote
It's prod with replication setup so I would like to see if there are other options...thanks!
Go to Top of Page

donpolix
Yak Posting Veteran

97 Posts

Posted - 11/06/2012 :  11:54:45  Show Profile  Click to see donpolix's MSN Messenger address  Send donpolix a Yahoo! Message  Reply with Quote
can you try dbcc updateusage?

Donn Policarpio
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.08 seconds. Powered By: Snitz Forums 2000