hallidayd (10/12/2010)

---

I remember also Rob Farley submitting a connect request to make some functions sargable since, logically, they could be: http://msmvps.com/blogs/robfarley/archive/2010/01/22/sargable-functions-in-sql-server.aspx

Chris Morris-439714 (10/12/2010)

---

I'm going to try for a brownie point

WayneS (10/12/2010)

---

I think instead of clearing the fog, we've managed to make it denser. :w00t:

HowardW (10/12/2010)

---

Ahhhhh, that'll teach me not to read the create table statement properly. Yes, with a indexed computed column it makes perfect sense.

jcrawf02 (10/12/2010)

---

I'm not sure that anybody jumping in (cough* Paul *cough) cleared any fog there...

HowardW (10/12/2010)

---

Mind=Blown 😀

Gianluca Sartori (10/12/2010)

---

Or, like me, question everything he pretends to know! 😛

HowardW (10/12/2010)

---

I wonder if the confusion arises due to the ISNULL function being non-SARGable?

Dave Ballantyne (10/12/2010)

---

It depends 🙂

Both are sargable, depending on the data being selected and the estimated rows

Gianluca Sartori (10/12/2010)

---

What I find surprising, is the predicate "IS NOT NULL" using an index seek.

hallidayd (10/12/2010)

---

Before seeing this thread, I'd never considered that anyone might think otherwise.

Brad McGhee did in 2007, and he's no thicky pants.

GilaMonster (10/12/2010)

---

...anyone using that for interviews has likely done themselves more harm than good.

GilaMonster (10/11/2010)

---

That I found a disprovable myth stated as truth on an MSDN blog didn't help.