Well, this was almost true for SQL Server 6.5 (only, the lowest locking level was a "block", not a "table"). And it caused a lot of problems, generating tons of deadlocks. Now, latest version of SQL Server provides for row-level locking, but not exactly the way Oracle does it, and also, it's unfortunate, that SQL Server can automatically escalate "row-level" lock to "block-level", or even "table-level". MS claims, it does this in order to improve performance. Sorry, don't have "first-hand" experience to "grade" this improvement in SQL Server.
Igor Neyman, OCP DBA [EMAIL PROTECTED] ----- Original Message ----- To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Friday, April 05, 2002 1:33 PM > There are some technical points worth considering. > For example, SQL Server does not have true row level > locking. It's table level locking, or some really > creative SQL to fake it. This has a direct impact on > scalability and performance. > > > --- DENNIS WILLIAMS <[EMAIL PROTECTED]> wrote: > > Oops, a couple of items I didn't make clear: > > - I was never able to compare the cost of Oracle > > support with the cost of > > Microsoft support. Oracle prices annual maintenance, > > which includes the > > right to upgrade to a new version of Oracle. MS > > prices out per incident or > > for all MS software at a location. If you can > > estimate the number of > > calls/month, then you could compare. > > - Oracle DBA salary vs. MS SQL DBA salary. I feel > > the difference is > > primarily due to less experience, training. I find > > it ironic that this > > probably causes less reliability for Microsoft > > (Microsoft has even > > complained that organizations don't assign their > > best people to administer > > MS products), yet then Microsoft brags about how you > > can save money because > > their people are cheaper. > > > > -----Original Message----- > > Sent: Friday, April 05, 2002 11:14 AM > > To: Multiple recipients of list ORACLE-L > > > > > > I recently prepared a total cost comparison between > > Oracle and MS SQL. I > > appreciate the support several people on this list > > provided me. In return, > > here are some of the main points I learned. > > - For smaller systems, investigate whether Oracle > > Standard Edition will > > meet your requirements. For example, most people > > assume that to use > > replication, you need EE. For our purposes the basic > > replication that comes > > with SE was adequate. > > - Microsoft also offers SQL in both EE and SE > > versions. Thanks very much > > to Gints Plivna for providing me a > > feature-by-feature comparison between the > > different versions. MS SE is not equivalent to > > Oracle SE. In most cases, the > > more valid comparison is between MS SQL EE and > > Oracle SE. > > - For maintenance, there are two parts to > > consider: Upgrade privilege and > > support. Oracle bundles both of these together. Make > > sure Microsoft is > > priced with Software Assurance, which gives upgrade > > privilege. Microsoft > > prices support by the incident or by the location > > (all Microsoft software). > > I was never able to get a comparison. > > - MS SQL EE with Software Assurance is actually > > more expensive than Oracle > > SE. Priced by the CPU. > > - Since pricing is by CPU and RISC systems offer > > higher database > > performance (according to many people on this list) > > and Oracle offers higher > > performance in a head-to-head comparison (according > > to the recently > > published Eweek benchmark), I compared Oracle SE on > > a 1-CPU Sun box with MS > > SQL on a 2-CPU Intel box. The Intel box was cheaper, > > but those two CPUs > > really kill you on licensing! In my mind I am > > convinced that both setups > > could offer equivalent performance. > > - I was provided figures that the average DBA > > salary (including health, > > vacation, etc.) on Oracle is $85,000 and on MS SQL > > $68,500. A leading > > industry analyst stated that the main reason MS SQL > > sites have less > > reliability is because there are few processes to > > ensure high availability, > > high performance. Developing these processes in the > > MS SQL world is more > > trial-and-error while these are well-documented in > > the Oracle world. I would > > add that several authors that participate in this > > list have created that > > documentation. > > > > Dennis Williams > > DBA > > Lifetouch, Inc. > > [EMAIL PROTECTED] > > > > -- > > Please see the official ORACLE-L FAQ: > > http://www.orafaq.com > > -- > > Author: DENNIS WILLIAMS > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services -- (858) 538-5051 FAX: > > (858) 538-5051 > > San Diego, California -- Public Internet > > access / Mailing Lists > > > -------------------------------------------------------------------- > > To REMOVE yourself from this mailing list, send an > > E-Mail message > > to: [EMAIL PROTECTED] (note EXACT spelling of > > 'ListGuru') and in > > the message BODY, include a line containing: UNSUB > > ORACLE-L > > (or the name of mailing list you want to be removed > > from). You may > > also send the HELP command for other information > > (like subscribing). > > -- > > Please see the official ORACLE-L FAQ: > > http://www.orafaq.com > > -- > > Author: DENNIS WILLIAMS > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services -- (858) 538-5051 FAX: > > (858) 538-5051 > > San Diego, California -- Public Internet > > access / Mailing Lists > > > -------------------------------------------------------------------- > > To REMOVE yourself from this mailing list, send an > > E-Mail message > > to: [EMAIL PROTECTED] (note EXACT spelling of > > 'ListGuru') and in > > the message BODY, include a line containing: UNSUB > > ORACLE-L > > (or the name of mailing list you want to be removed > > from). You may > > also send the HELP command for other information > > (like subscribing). > > > ===== > Pete Barnett > Lead Database Administrator > The Regence Group > [EMAIL PROTECTED] > > __________________________________________________ > Do You Yahoo!? > Yahoo! Tax Center - online filing with TurboTax > http://taxes.yahoo.com/ > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Peter Barnett > INET: [EMAIL PROTECTED] > > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California -- Public Internet access / Mailing Lists > -------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Igor Neyman INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
