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 |
|
jblake
Starting Member
2 Posts |
 Posted - 2009-08-12 : 02:09:28
|
| I have a 110Gb table that will not shrink after a index rebuild or Database shrink.When I restore this database to another server the table is only 15GB with same amount of records.This is a table that does have a large amount of Inserts/deletes and there are XML columns(FYI).The index is a Clustered index |
|
|
MonikaK
Starting Member
6 Posts |
Posted - 2009-08-13 : 10:30:41
|
| Try taking a t-log backup after the rebuild index task. This should help you out. |
 |
|
|
jblake
Starting Member
2 Posts |
Posted - 2009-08-13 : 11:04:19
|
| I ran the following:declare @DBID int, @ObjID intselect @ObjID= OBJECT_ID(N'<tableName>')select @DBID=db_id()SELECT alloc_unit_type_desc, page_count, avg_page_space_used_in_percent, record_count, *FROM sys.dm_db_index_physical_stats(@DBID, @ObjID, NULL, NULL , 'Detailed');And .... I have LOB_DATA with 14Million+ Ghost_record_count.Thanks |
|
|
|
|
|
|
Shrink Table