We use SQL Server 6.5 which, as I understand, stores data in 2k pages. Thus, if you have at table that has a record length > 1k, you will actually use a full 2k page to store one record.

We are currently in the process of vertically splitting this table. It has a record length of 1200, but when complete, will be only 625.

In theory, this means instead of getting 1 record per 2k page, I should be able to get 3 records per 2k page.

We are doing this split to get rid of unneeded data and reduce the size of the database.

My question comes down to this:
When you look at the space used for a database in EM, is this number the actual physical space used, or is accounting for the entire 2k page that was used to store the record(s)?

I'm thinking that by reducing the record length, not only do I save space on the unused data, but I should also save space by being able to fit more records on a page, thus reduce the wasted space on that data page.

Can anyone tell me if I'm on the right track here?????