I am currently trying to reduce the storage space of a 80
GB SQL Server 7.0 database.
One Major work i am trying to do is to convert all the
datetime datatype columns to smalldatetime and all numeric
datatype columns to int.
Since 30% of the columns in the database have columns of
this datatype. This should reduce the storage space.
After i changed the column type of all the tables. I don't
see any change in storage space per table. I got the info
Even after i issue dbcc dbreindex, and then sp_spaceused ,
these is not difference in the storage allocation.
Is there any other way of doing this.
Thanks in advance