Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
SQL_Gaga
Starting Member
2 Posts |
 Posted - 2012-11-05 : 16:45:37
|
| 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 KBWhen I delete all the rows (in test), there is still some reserved space.Table_Name 0 2670648 KB 2664040 KB 88 KB 6520 KBMicrosoft SQL Server 2008 R2 (SP1) - 10.50.2806.0 (X64) Thanks a lot! |
|
|
Bustaz Kool
Master Smack Fu Yak Hacker
1834 Posts |
Posted - 2012-11-05 : 17:07:11
|
| 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 |
 |
|
|
SQL_Gaga
Starting Member
2 Posts |
Posted - 2012-11-05 : 17:11:49
|
| It's prod with replication setup so I would like to see if there are other options...thanks! |
|
|
|
donpolix
Yak Posting Veteran
97 Posts |
Posted - 2012-11-06 : 11:54:45
|
| can you try dbcc updateusage?Donn Policarpio |
|
|
|
|
|
|
deleting a large number of rows