opc.three (3/27/2013)
GilaMonster (3/27/2013)
opc.three (3/27/2013)
At 50% I would rebuild. If you're having trouble with log size look into partitioning your table and indexes so you can rebuild smaller subsets of your index, ie only the partitions that need it.Or switch to bulk-logged recovery model if possible.
True. That will help keep log size down but could increase tran log backup sizes.
OK, maybe negligibly larger. I have not paid too much attention to the actual differences but know they are larger. With a ton of index rebuild activity I figured it would be noticeable but maybe not as much I figured.
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato