Hello Gail

Just got an email from the DBA saying that he had shrunk the DB as a maintenance measure after rebuilding the indexes. I thought - based purely on what I have read - that this was a sure fire way to fragment the indexes again, effectively undoing the good of the index rebuild. Is it possible to shrink without fragmenting, or should we steer away from shrinking altogether?

I need to be sure of my facts before I proceed.

Mark Dalley