As usual, nice article Steve. I've read other articles and explanations of showcontig and still came away confused, but this puts it into a more clear light. I also have the luxury of running dbcc dbreindex on our production database, but it does not shrink the data like David experienced (at least not very much). We only run it once per release, or every few months.

-Vic