Re: What's wrong with SQL Server?

From: JEDIDIAH <jedithezealot_at_yahoo.com>
Date: 25 Jun 2003 14:22:25 -0700
Message-ID: <5121813f.0306251322.228f6d81@posting.google.com>

Billy Verreynne <vslabs_at_onwe.co.za> wrote in message news:<bccauc$jb7$1_at_ctb-nnrp2.saix.net>...
> Franklin wrote:
>
> > From this link:
> > In SQL Server, the DBA has no "real" control over sorting and cache
> > memory allocation.
> <loads snipped>
>
> So friggen what!?

An RDBMS is not just a souped up version of MSOffice. It's an entire development environment. As such, every database can be unique with distinct requirements and bottlenecks. The more you can do to customize the product to individual sites, the more likely you are to get the best performance out of the RDBMS and minimize cost. Also, it's naive to expect the RDBMS to be effective at tuning itself. Sometimes you need to be able to "throw the manual away" in order to tune effectively.

If your needs really so trivial, why not just use mysql or postgres? Received on Wed Jun 25 2003 - 16:22:25 CDT