August 12, 2009 at 1:47 am
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
August 12, 2009 at 6:20 am
Duplicate post. No replies to this thread please. Direct replies to:http://www.sqlservercentral.com/Forums/Topic769118-5-1.aspx
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply