Re: Why can't recursive queries contain...?

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Michael Coles (admin@xxxxxxxxxxxxxx) writes:
The SQL Server optimizer is the result of 2 decades of R&D, production
implementations and response to customer feedback. To completely start
creating a new transactional database engine from scratch based on the
OO model (as opposed to relational), complete with an
"industrial-strength" optimizer would require huge investments of time,
money and resources. It would also require huge investments in
marketing, trying to convince people they need this new DBMS while not
annihilating the client base for your SQL DBMS. I'm sure it could be
done, but is it worth it to anyone? Who knows...

Object-oriented databases exists, or at least they existed in the first
half of the nineties, when was the days I heard about them. I seem to
recall that there were a few areas where they were better than relational
databases, like CAD. But it is quite clear that for one reason or another,
they have not been able to do a major breakthrough.

--
Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
.

Relevant Pages

  • Re: Moving system databases in SQL 2005
    ... code and the folder name listed in the error message are different. ... Start SQL Server service. ... work for all system databases in 2005 except the master and resource ... Download the latest version of SQL Server 2005 Books Online from ...
    (microsoft.public.sqlserver.setup)
  • Re: why>?
    ... On your desktop-- you'll be running SQL Server behind the scenes. ... it isn't risky to allow end users to create databases. ... it is no more risky than giving you the ability to create spreadsheets. ... I'm not saying that Oracle and IBM are going away. ...
    (microsoft.public.excel)
  • Re: sql 2000 - slow response times after creating a new database
    ... SQL server does not create indexes automatically. ... Statistics are involved with choosing the query plan and such decisions may ... Books Online for more info about the ITW. ... >>>usual system databases. ...
    (microsoft.public.sqlserver.dts)
  • Re: sql 2000 - slow response times after creating a new database
    ... SQL server does not create indexes automatically. ... Statistics are involved with choosing the query plan and such decisions may ... Books Online for more info about the ITW. ... >>>usual system databases. ...
    (microsoft.public.sqlserver.server)
  • Re: sql 2000 - slow response times after creating a new database
    ... SQL server does not create indexes automatically. ... Statistics are involved with choosing the query plan and such decisions may ... Books Online for more info about the ITW. ... >>>usual system databases. ...
    (microsoft.public.sqlserver.setup)