Thank you for the reply. I went to see what I could find on the reports and realized that we haven't yet installed SP2 (the reports weren't where I'd...

To find the details I right click the table then Properties / General / Storage and look at 'Data Space' and 'Index Space'.

Logic says that indeed the physical space should...

Thanks for your interest. I hadn't rebuilt the clustered index so I went and rebuilt all indices and there was no change to the sizes for either the index or...