asked
DBCC SHRINKDATABASE V/S INDEX FILL FACTOR {%}
Hi, Does shrinking database reclaim index fill factor {%} from page also or fill factor % will be available still in page?
DBCC SHRINKDATABASE will move datapages, not data within datapages, so the fillfactor should remain the same. What will happen though is that you are likely to get fragmentation from shrinking database files.
As I know shrink database will increase index fragmentation because it moves data pages so we can DE-fragment indexes through reorganization of indexes, Is there will be more benefit If we do rebuild instead of reorganization after shrink or Re-organization is sufficient?
If you have much fragmentation, you get a better result using rebuild than reorganize. But reorg and rebuild are likely to grow your database file again.
You're right - reorg won't grow datafile. But on the other hand - it won't defragment very effectively either :)
+1 I agree with Magnus. If you want to keep the growth to a minimum when using rebuild, you should specify the SORT_IN_TEMPDB option.
