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

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

"Michael Coles" <admin@xxxxxxxxxxxxxx> wrote in message
news:FCC6E2B4-2B6A-45C8-BDF5-
The SQL Server optimizer is the result of 2 decades of R&D, production
implementations and response to customer feedback.

Do you really think this declarative approach works that well? I still find
that I tell that database what I want to do and a lot of the time it does it
the wrong way and I have to go back in and tell it how to do it anyway.

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...

Nothing is impossible. No one was screaming for .net but it's been a big
success.

You spoke previously of your dislike of backwards-compatibility features
in SQL Server, etc. But it is precisely because people don't immediately
upgrade to the newest versions and convert all their existing code to use
all of the latest and greatest features that these backwards-compatibility
features even exist...

That's true but I am only 1 version behind. Besides, I'm not against
backwards compatibility, I just think that after a certain point in time it
becomes necessary to make a complete break from the past sins. We're still
in the very early stages of computing in 2009, do we really want sql2050 to
still only be able to return a square block of data from a stored proc?

Michael


.

Relevant Pages

  • Re: Open Mouth - Insert Foot
    ... capability [backwards compatibility], along with a few other features, ... isn't dramatically reducing Sony's cost of manufacturing the console ...
    (alt.games.video.xbox)
  • Re: Open Mouth - Insert Foot
    ... capability [backwards compatibility], along with a few other features, ... isn't dramatically reducing Sony's cost of manufacturing the console ...
    (alt.games.video.xbox)
  • Re: OT - Cell phones
    ... If you are on the road a lot one of the best investments you can make is ... a BT speakerphone. ... Mine announces the incoming caller and does a very ... how cell-phones have dozens of features so one ...
    (alt.home.repair)
  • Re: StringIO in 2.6 and beyond
    ... The intention is to make the transition from 2.x to 3.x ... easier by adding some features of 3.x to 2.x, but without breaking ... backwards compatibility. ...
    (comp.lang.python)
  • Re: StringIO in 2.6 and beyond
    ... The intention is to make the transition from 2.x to 3.x ... easier by adding some features of 3.x to 2.x, but without breaking ... backwards compatibility. ...
    (comp.lang.python)