I know at the time that MS started using the Sybase code, it was still page-level, as opposed to row-level locking, and that was the _SINGLE_ biggest obstacle to competing with Oracle.
I believe that at least two MS versions with that code base were released, all the while there was a full-court press within MS to rebuild to support the more granular locking model. This was SQL Server 7, IIRC. It was pretty much a ground-up MS product at that point. -sc -----Original Message----- From: Kurt Buff [mailto:kurt.b...@gmail.com] Sent: Thursday, July 15, 2010 6:43 PM To: NT System Admin Issues Subject: Re: Whining... Does Sybase really still share the same core code as MS-SQL? It's been a *long* time since they split. On Thu, Jul 15, 2010 at 15:25, Michael B. Smith <mich...@smithcons.com> wrote: > Heh. > > Not a fan-boi at all. Neither MySQL or PostgreSQL has the rich set of > capabilities present in the MS-SQL, DB2, or Oracle _platforms_. Note that for > those three, it isn't just a database engine, it's an entire suite of > capabilities, programs, and systems. > > I'm not saying that they aren't fine products. I've used both fairly > extensively in various projects over the last dozen years. I've even > implemented MySQL solutions with striped databases and HA to enhance > performance and scalability for that solution. > > But to say that either of those has the rich infrastructure support and > analytic and BI capabilities of DB2, Oracle, or MS-SQL? That's simply not > true. > > Also, to look at performance and scalability, look at www.tpc.org. For > databases at 1 TB or larger, you do not find either MySQL or PostgreSQL > listed. You have the three I mentioned, plus Sybase (which shares the same > core codebase as MS-SQL) plus a special purpose database for OLTP. > > Regardless, we are all allowed to have our opinions. :-) > > Regards, > > Michael B. Smith > Consultant and Exchange MVP > http://TheEssentialExchange.com > > > -----Original Message----- > From: Joseph L. Casale [mailto:jcas...@activenetwerx.com] > Sent: Thursday, July 15, 2010 5:56 PM > To: NT System Admin Issues > Subject: RE: Whining... > >>Scalability. >> >>Performance. > > Well, I'd say there are a lot of nix based apps that require this and > get it out of my or pg:) > >>Operating systems. > > Yes, if your an MS shop without any nix experience, you have no choice... > Do what you know... > >>I wrote an application for a customer that had to support three database >>platforms (Access [arguably not a real database, but still...], MySQL, and >>MS-SQL). It was a nightmare >getting it all right. > > Right, but that doesn’t address the inquiry as to why it wasn’t > written for *one* to start:) If you write it for MS, it’s the same amount of > work if you start out and write it for My or pg. > >>IMO, MS-SQL, Oracle, and DB2 are the "enterprise DB platforms" providing full >>support for clustering, mirroring, geographic dispersion, business >>intelligence, business >analytics, reporting, etc. MySQL and PostgresSQL >>aren't bad - but they aren't (again, IMO) full blown business analytic >>platforms. > > C'mon Michael, seriously? That’s a bit fan-boyish?:) With the utmost > GREATEST respect to you, I humbly disagree... > > There are some people that think opensource ware is simply a toy, > while sometimes the model promotes very good code and very extensive > features sets. My and PG have some pretty impressive HA models to work with. > > My $0.02 Canadian worth of opinion:) > > ~ Finally, powerful endpoint security that ISN'T a resource hog! ~ ~ > <http://www.sunbeltsoftware.com/Business/VIPRE-Enterprise/> ~ > > ~ Finally, powerful endpoint security that ISN'T a resource hog! ~ ~ > <http://www.sunbeltsoftware.com/Business/VIPRE-Enterprise/> ~ ~ Finally, powerful endpoint security that ISN'T a resource hog! ~ ~ <http://www.sunbeltsoftware.com/Business/VIPRE-Enterprise/> ~ ~ Finally, powerful endpoint security that ISN'T a resource hog! ~ ~ <http://www.sunbeltsoftware.com/Business/VIPRE-Enterprise/> ~