Re: Which is faster? <> or Between

Isaac Blank wrote:

> "Daniel Morgan" <damorgan_at_exxesolutions.com> wrote in message
> news:3F00CE4C.E10A09DE_at_exxesolutions.com...
>
> > Fine. But the concept here is one of moving code from Development to Test
> to
> > Production.
> >
> > When it is in production it belongs to the production DBAs, not the
> developers
> > or the testers.
>
> When there is a performance problem in production, DBAs can only detect
> it. It is very seldom that they can fix it - usually when they themselves
> screwed it up by dropping an index or messing up statistics, etc. So they
> will turn to the developer on call for diagnostics and resolution.

Then I'd either hire new DBAs that know their job or train the ones you have.

A DBA that can't tune is a just a SysAdmin.

--
Daniel Morgan
http://www.outreach.washington.edu/extinfo/certprog/oad/oad_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)