Path: news.f.de.plusline.net!news-fra1.dfn.de!newsfeed.hanau.net!newsfeed01.sul.t-online.de!t-online.de!news.germany.com!postnews.google.com!d57g2000hsg.googlegroups.com!not-for-mail
From: "hpuxrac" <johnbhurley@sbcglobal.net>
Newsgroups: comp.databases.oracle.server
Subject: Re: Slightly OT: Size of Oracle vs MS SQL database tables
Date: 12 Apr 2007 06:24:41 -0700
Organization: http://groups.google.com
Lines: 28
Message-ID: <1176384281.684691.202460@d57g2000hsg.googlegroups.com>
References: <tfGdnVai95UvtoPbnZ2dnUVZ_rCsnZ2d@insightbb.com>
NNTP-Posting-Host: 208.44.49.5
Mime-Version: 1.0
Content-Type: text/plain; charset="iso-8859-1"
X-Trace: posting.google.com 1176384282 22032 127.0.0.1 (12 Apr 2007 13:24:42 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Thu, 12 Apr 2007 13:24:42 +0000 (UTC)
In-Reply-To: <tfGdnVai95UvtoPbnZ2dnUVZ_rCsnZ2d@insightbb.com>
User-Agent: G2/1.0
X-HTTP-UserAgent: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0; .NET CLR 1.1.4322; .NET CLR 2.0.50727),gzip(gfe),gzip(gfe)
X-HTTP-Via: 1.0 PROXY
Complaints-To: groups-abuse@google.com
Injection-Info: d57g2000hsg.googlegroups.com; posting-host=208.44.49.5;
   posting-account=Dz_3bQ0AAAC5LZNB2NPEJz1sl_a8qcDY
Xref: news.f.de.plusline.net comp.databases.oracle.server:196296

On Apr 12, 8:53 am, m...@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

What exactly has caused this change in the database sizes?

If your organization has already completed on move it looks like you
should dig in and research in detail what is different and why it is
different.

4K worth of data is still the same amount in oracle or sql server ...
what type of changes were made in how you have organized data and
indexes?