Thanks for the replies. It sounds possible that it's a problem with UPDATEs re-writing data at the end. I have tried this with small test script which inserted...

I used the DBCC UPDATEUSAGE method instead which seems do the same.

The output from DBCC SHOWCONTIG is as follows. Page density is very low at 19%, which seems to...