Very Computer

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
using sp_spaceused.

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

The dbreindex command will only save space if the fill
factor + decrease in row size allow you to get more rows
on a page

Quote:>-----Original Message-----
>Hi All

>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
>using sp_spaceused.

>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
>.

www.SQLDTS.com

On Wed, 17 Jul 2002 05:08:00 -0700, "Richard Siddaway"