Re: Slightly OT: Size of Oracle vs MS SQL database tables

Michael L. Squires wrote:
> I'm working at a place where we're moving from an Oracle 10g environment to
> a mixed Oracle/MS SQL Server 2005 environment. (Main reason is cost; the
> Oracle software bid was five times the MS bid).
>
> We've moved one database over to MS SQL Server 2005 and have discovered that
> all of our data tables more than double in size under MS SQL Server 2005.
> The net effect is to more than double the amount of disk space required to
> implement the same database.
>
> A search of various sources of MS information haven't turned up a magic
> switch to reduce the size of these tables.
>
> Any pointer to some information about this difference, expecially if there's
> something obvious that we're missing, would be greatly appreciated.
>
> Mike Squires

Characterset differences perhaps?

-- 
Niall Litchfield
Oracle DBA
http://www.orawin.info/services