Re: Is MS-SQL6.5 in the same league as Oracle, Sybase?

Harold -

Not to sound like a Micro$oft salesman, but does a 50 million record database need things like this?

  > - distributed optimiser (& distributed joins)   > - Distributed join capability

I was doing 10s of millions of records in my FoxPro days. (In case you're skeptical, MCI Perspective [written in FoxPro 2.5 for DOS] handled [slowly] some customers whose MONTHLY data was too large to fit onto 1 CD). I'm not an ORACLE user, but my friends on the other side doing 'bleeding edge' things like parallel processing on ORACLE/SP/2 say that it works as long as your tables aren't indexed.

IMHO, MS SQL Server is on the path the being THE midrange database, especially with the GUI interfaces (under development) and Wizards and the like.

Michael Lascuola
MCI Systems Engineering

Gordon E. Hooker wrote:
>
> roussel_at_physics.mcgill.ca (Harold Roussel) wrote:
>
> >The title says it all. I need to find a good SQL database system for
> >handling up to 50 million records (database size of a few gigs) and I
> >was wondering if I should limit my choice to Oracle or Sybase. What
> >about advanced features like data encryption, mirroring, etc? Is
> >MS-SQL up to the task? Thanks for any information.
> >
> Not from the press I have seen in relation to MS-SQLServer,
> although Microsoft say they have an enterprise solution
> that is far from the truth without going into too much
> detail here are a number of features that are part of Oracle that
> are not in MS-SQLServer:
>
> - Symmetric replication
> - Full row-level locking
> - Full parallel capabilities
> - Bit-mapped indexing
> - Star query optimisation
> - Object repository
> - distributed optimiser (&distributed joins)
> - User-defined functions
> - Support for loosely-coupled systems
> - Support for MPP systems
> - Support for 64-bit memory systems
> - Distributed join capability
> - Hierarchical data-types
> - Multi-protocol interchange
>
Received on Fri Oct 11 1996 - 00:00:00 CEST