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: oracle is crap how to switch to ms-sql

Re: oracle is crap how to switch to ms-sql

From: Daniel A. Morgan <damorgan_at_exesolutions.com>
Date: Sun, 12 May 2002 12:10:08 +0100
Message-ID: <3CDE4D90.393D2BDD@exesolutions.com>


Mark D Powell wrote:

> "Fred Nurk" <frnurk_at_yahoo.com.au> wrote in message news:<44rD8.8700$b5.28915_at_newsfeeds.bigpond.com>...
> > What about "master-bates" ?
> >
> > koert54 wrote in message ...
> > >maybe you should rename your nick from 'master-dba' to 'crap-dba'
> > >
> > >"master-dba" <master-dba_at_aol.com> wrote in message
> > >news:abl9o6$ocm$01$1_at_news.t-online.com...
> > >> hi,
> > >>
> > >> oracle is so old-fashioned how easily can one switch to
> > >> foxpro or access ?
> > >>
> > >> or should I use sqlserver ?
> > >>
> > >> can i operate it with a windows-gui ?
> > >>
> > >> we have a large database with 300mb which is very slow,
> > >> can such a huge database be loaded in sql-server ??
> > >>
> > >> what hardware do i need ?
> > >>
> > >> we work with oracle 7.0.1.3.4.5 on novell
> > >>
> > >>
>
> The release of Oracle you are complaining about is at least 7 years
> old. The never releases come with several GUI tools. Perhaps you
> should consider upgrading to a supported version, and then you would
> be making a fairer comparison.
>
> Also 300MB is a very small database; Out main OLTP has tables whose PK
> size exceeds 300MB. Performance of any database is at least partially
> dependent on the hardware configuration upon which you run it, and on
> the tuning effort put into the application SQL/objects. When was the
> last time any of the indexes in your problem system were rebuilt?
> Statistics updated? Tables re-organized?
>
> HTH -- Mark D Powell --

Mark ... do everyone a favor ... encourage him, as I did, to work with Microsoft tools.

He has a problem. But only a small part of it involves technology.

Daniel Morgan Received on Sun May 12 2002 - 06:10:08 CDT

Original text of this message

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