Hi Gail,

I've just found that a lot of our databases have had the same setting.

They are on small servers, with RAID 5 or RAID 10.

I know we could fix the external fragmentation with a backup/restore.

I think it would also be possible to fix the problem if we created a new file group (apart from PRIMARY), and then REBUILD all index onto the new file group.

A few of the MDF files do not have many fragments. So there is no external fragmentation.

What about the internal fragmentation?

Do I need to worry about that?

TIA,

Henrik