RE: Limitations of MSSQL Server Vs. Oracle OR simply otherwise limitations in general - OT

 We have several fairly large data warehouses that run on SQLServer. The performance is quite acceptable (provided the database is installed on a good enough SAN). SQLServer is still missing some nice features of Oracle (for example, no partitions -- need to use partition views, and read performance seems to degrade greatly in proportion with the number of partitions). Oracle's pricing, based on both cpu's + number of users, really discriminates against DW shops, which need powerful/multiple CPUs, but, for DSS's, may not have very many users.

Leslie
Leslie Tierstein
Senior Consultant
Vision Chain, Inc.
The first software to power the demand data network phone: 202-261-3549

-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of ryan_gaffuri_at_comcast.net
Sent: Tuesday, November 23, 2004 9:56 AM To: lex.de.haan_at_naturaljoin.nl; VIVEK_SHARMA_at_infosys.com; 'ORACLE-L' Cc: Lex de Haan
Subject: RE: Limitations of MSSQL Server Vs. Oracle OR simply otherwise limitations in general - OT

There appear to be some very large OLTPs running sql server. Someone posted a link to a list of the largest databases in the world and several of them run on SQL Server. I have not used it, but I have been told it improved alot in the last two years. This might explain why oracle is lowering the prices for small to mid-level shops that threaten to go to sql server...=20

--

http://www.freelists.org/webpage/oracle-l
--

http://www.freelists.org/webpage/oracle-l Received on Tue Nov 23 2004 - 18:21:12 CST