Re: SQL Server 2005 - Still not upto it

> Interesting article but a couple months back Infoweek carried an
> article that stated that the beta version was missing the optimizer.

I'd like to see that article. :-)
The execution engine cannot execute an SQL query. It needs a execution plan. The execution plan is generated by the optimizer.

Now, the optimizer might not have been as polished at that point in time as it will be in the released version, but that is of course the case with all parts of a product.

-- 
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/


"Mark D Powell" <Mark.Powell_at_eds.com> wrote in message 
news:1110919612.865818.22150_at_l41g2000cwc.googlegroups.com...


> Interesting article but a couple months back Infoweek carried an

> article that stated that the beta version was missing the optimizer.

> If I was in charge of the project I would want the otimizer beta tested

> also, but just because I think all the code should be beta tested does

> not mean MS's approach is wrong.  It does however raise questions about

> why the beta engine is claimed to be non-optimizing.  It could be that

> MS is having trouble getting the optimizer to work correctly, or they

> could be planning to spring a surprise.  In another few months we will

> find out.

>

> -- Mark D Powell --

>