Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Slightly OT: Size of Oracle vs MS SQL database tables

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

From: gazzag <gareth_at_jamms.org>
Date: 12 Apr 2007 09:13:51 -0700
Message-ID: <1176394431.833988.253520@n59g2000hsh.googlegroups.com>


On 12 Apr, 13:53, m..._at_familysquires.net (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

Don't most MS "solutions" require twice as much disk space as anything else? ;-)

-g Received on Thu Apr 12 2007 - 11:13:51 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US