FW: SQL-Server Presentation/Reality Check

From: Henry Poras <Henry.Poras_at_ctp.com>
Date: Thu, 28 Jun 2001 08:36:07 -0700
Message-ID: <F001.0033C1F7.20010628084232@fatcity.com>

Ooooh. Is that the origin of the Seven Year Itch??

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

Sent: Wednesday, June 27, 2001 6:50 PM
To: Multiple recipients of list ORACLE-L

Microsoft itself will tell you that it won't allow you to read a record/row that someone is actively changing.

They give a few examples that make very good sense to yours truly.

I am sure that others can come up with examples that make it look like the stupidest thing since poisonivy-based condoms.

It all tells you one thing though: NT Sucks.

<EG>

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

Sent: Wednesday, June 27, 2001 5:35 PM
To: Multiple recipients of list ORACLE-L

Can you provide some references to lack of support of read-consistency. Not that I don't believe you but I just read that to a guy next to me and he is clamoring for evidence. - E

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

Sent: Wednesday, June 27, 2001 2:07 PM
To: Multiple recipients of list ORACLE-L

Privilege ? Reality? Reality and MS is an oxymoron. I've had the fortune (misfortune) to become a SQL Server DBA in addition to my Oracle duties, due to packaged application requirements. As an admitted defiler of all MS stands for and it's dubious accomplishments, I'll offer a few grains of sand, most of which you might be advised to take up with management away from the MS marketing morons.

First, be aware that MS pricing is not nearly as inexpensive as their hype would have you believe, once you remember that they have always charged for upgrades, their discounts aren't usually as steep, and support... well, what there is of it s****. I've spent 3 calls at $245.00 each only to be told each time the answer was to 'reboot'. This on W2K/SS2K fail-over cluster, with many of their best support people contributing to this non-solution.

On a technical note: Virtually every one of their new speed marks of note have been done on multi-server clusters; Oracle still holds most single-server benchmarks. Additionally, their application benchmarks have no relationship to real world, as even their SAP benchmark was done on a modified SAP installation not available in 'ordinary' SAP applications. The overhead of multi-server/cluster management makes their scalability arguments, even if they could be accommodated by existing software, moot.

Self-Tuning - Bah, Humbug. I've had the opportunity to see some server code from SAP, PeopleSoft and Commerce One designed for SQL Server. Guess what ? The real stuff, that which has to perform, is often hinted (statements like 'option (loop join , force order, maxdop 1 )' which is pretty much self explanatory; 'maxdop 1' = Oracle's noparallel.)

Then there's the entire discussion of read-consistency, which SQL Server doesn't support. A whole thread there, and one reason why SQL Server can be very quick in some operations: No RBS to support. Everything is done from the transaction logs.

And then there's functionality...

Just my 2 cents...

Ed Maurer
Sr. DBA
Acquirex

also send the HELP command for other information (like subscribing).

--

This e-mail is intended for the use of the addressee(s) only and may contain privileged, confidential, or proprietary information that is exempt from disclosure under law. If you have received this message in error, please inform us promptly by reply e-mail, then delete the e-mail and destroy any printed copy. Thank you.

==
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Post, Ethan
INET: epost_at_kcc.com

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: ListGuru_at_fatcity.com (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: Mohan, Ross
INET: MohanR_at_STARS-SMI.com

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

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