SARGability

Where can I find a good discussion of this, with tips on making use of it?
Peace & happy computing,
Mike Labosh, MCSD
"Escriba coda ergo sum." -- vbSensei"Inside SQL Server" by Kalen Delaney has a good discussion on it IIRC.
Jacco Schalkwijk
SQL Server MVP
"Mike Labosh" <mlabosh@.hotmail.com> wrote in message
news:%239YDJhrPFHA.508@.TK2MSFTNGP12.phx.gbl...
> Where can I find a good discussion of this, with tips on making use of it?
> --
> Peace & happy computing,
> Mike Labosh, MCSD
> "Escriba coda ergo sum." -- vbSensei
>|||Mike Labosh wrote:
> Where can I find a good discussion of this, with tips on making use
> of it?
>
This is a pretty good article:
http://www.sql-server-performance.com/transact_sql.asp
Recently Gert pointed out to me that some of it is outdated: for example, it
turns out that "IS NULL" is now sargable, contrary to what the author of the
article says. See this thread:
http://groups-beta.google.com/group...6d308880bcc9f64
Bob Barrows
--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.