Viewing 15 posts - 1 through 15 (of 28 total)
Seraj Alam-256815 (10/25/2010)
Did you run "sp_spaceused @updateusage= 'true'"? Hope it fixes.
Alternately, pl try below;
Create a filegroup and aleter table to move to the new file group.
Then again move the table...
October 25, 2010 at 11:00 am
Juliet20120 (10/25/2010)
You can run Truncate table to free space.
Juliet20120, please read the entire post.
October 25, 2010 at 10:58 am
Oksana March (10/23/2010)
October 25, 2010 at 10:54 am
Yujie Fu (10/22/2010)
Did you tryTruncate table mytable
Yes, it released a table space but in production we did DELELE and stuck with the issue.
October 22, 2010 at 11:18 am
After working with Microsoft the workaround was found:
There is a known issue where on a database having a LOB data in it, the SHRINK operation will only shrinks one empty...
October 21, 2010 at 12:51 pm
Yes, I did DBCC CleanTable. Also, in my earlier results for DBCC SHOWCONTIG the ForwardedRecords=0 as any other field except ScanDensity=100.
I'll try to contact MS and let you know.
September 29, 2010 at 6:59 am
Yes, might be an issue - I'll investigate tomorrow but now here is results of your script
DatabaseNameobject_idTableNameforwarded_record_countindex_type_desc
Test2045250341MyTable0HEAP
Test2089058478sysdiagramsNULLCLUSTERED INDEX
Test2089058478sysdiagramsNULLCLUSTERED INDEX
Test2089058478sysdiagramsNULLNONCLUSTERED INDEX
September 28, 2010 at 2:43 pm
CirquedeSQLeil (9/28/2010)
I find that extremely odd. Can we get the DDL for this table? Including the indexes?
CREATE TABLE [MySchema].[MyTable](
[ID] [int] IDENTITY(1,1) NOT FOR REPLICATION NOT NULL,
[RcID] [int] NOT...
September 28, 2010 at 12:43 pm
Really weird. I removed everything in db except that table and everthing inside the table except columns (row count = 0) and the size issue is still over there. Neither...
September 28, 2010 at 11:55 am
Well, finally I gave up and dropped and created the table.
Before that I removed everything from that table (PK, FKs, indexes, constraints) and run delete, truncate but nothing has changed...
September 28, 2010 at 8:42 am
Michael Valentine Jones (9/27/2010)
Have you verified that the table is not a heap (has a clustered index)?
It has a cluster index but right now I removed ALL indexes, run 'delete...
September 27, 2010 at 2:59 pm
CirquedeSQLeil (9/27/2010)
check dbcc opentranI wonder if there is something that is preventing the table from releasing space
Also, is the db in full or simple?
No active open transactions (it was restored...
September 27, 2010 at 2:55 pm
Derrick Smith (9/27/2010)
Or better yet, drop the indexes so the table is a heap, then delete with tablock, then recreate the...
September 27, 2010 at 2:53 pm
CirquedeSQLeil (9/27/2010)
To recap:sp_updatestats did not work
dbcc updateusage did not work
dbcc checkdb shows no corruption?
The table is replicated
Index Rebuild did not work
Truncate table did not work
Are there any pending replication actions?
Nothing...
September 27, 2010 at 2:48 pm
CirquedeSQLeil (9/27/2010)
miksh (9/27/2010)
Btw, one of the columns of XML type if it helps you.How many indexes?
Have all indexes been defragged / rebuilt?
Yes, even dropped and created
September 27, 2010 at 2:47 pm
Viewing 15 posts - 1 through 15 (of 28 total)