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

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

>
>
>//
>// Harold Roussel email: roussel_at_physics.mcgill.ca
>// Ph.D. student phone: (514) 398-6506
>// High Energy Physics
>// McGill University, Montréal, Québec
>//
>// Using OS/2 Warp and NT 3.51.
>//
>// "Mais je vais être frénétique et fulminant, il me faut une armée entière à
>// déconfire. J'ai dix coeurs, j'ai vingt bras. Il ne peut me suffire de
>// pourfendre des nains, il me faut des géants." Cyrano de Bergerac
>
Received on Thu Oct 10 1996 - 00:00:00 CEST