Viewing 4 posts - 1 through 4 (of 4 total)
We managed to find a workaround for problem;
http://technet.microsoft.com/en-us/library/ms179586%28SQL.90%29.aspx
...need to find out why its happening though!!
October 13, 2011 at 5:45 am
Rebuild or reorganise of the clustered index should reduce the amount of unused space within a table.
We do a reindex of the database each week regardless if it requires it...
May 5, 2011 at 1:23 pm
The shrinkfile operation runs continuous all week, it stopped on a Monday evening where the indexes are rebuilt but not with LOB compaction, we tried LOB compaction on the DR...
May 5, 2011 at 8:51 am
Hi Jerry,
All the re-indexing is offline as its uses the DBCC DBReindex and the fragmentation figure (taken from data diagnostic tool idrea ) is usuallu below 10%.
I have read that...
November 28, 2008 at 9:15 am
Viewing 4 posts - 1 through 4 (of 4 total)