Evil Kraig F (12/20/2013)

---

ScottPletcher (12/20/2013)

---

Admittedly the gain is much clearer when the clustering key is the ISNULLed column. So, let's just flip the clustering keys on your original table...

Evil Kraig F (12/20/2013)

---

ScottPletcher (12/20/2013)

---

Admittedly the gain is much clearer when the clustering key is the ISNULLed column. So, let's just flip the clustering keys on your original table...

Evil Kraig F (12/20/2013)But, I'd like to bring us back to the origination of this minor alteration in the direction of this topic, and that's SARGability and effeciency and if...

Evil Kraig F (12/20/2013)

ScottPletcher (12/20/2013)

---

There could be great harm in it if either (1) SQL could have done seeks on both terms and produced the final output more efficiently than...

Jeff Moden (12/20/2013)

---

ScottPletcher (12/20/2013)

---

Jeff Moden (12/20/2013)

---

ScottPletcher (12/19/2013)

---

I don't object to ISNULL() in the SELECT list, just in WHERE conditions. Since it shouldn't be used in WHERE, it's only consistent...

Jeff Moden (12/20/2013)

---

ScottPletcher (12/19/2013)

---

I don't object to ISNULL() in the SELECT list, just in WHERE conditions. Since it shouldn't be used in WHERE, it's only consistent not to use...

Snargables (12/19/2013)

---

I had to create an index that added all the columns in the include of the index. This was because i created a function that has to return all...

wolfkillj (12/19/2013)

---

ScottPletcher (12/19/2013)

---

Jeff Moden (12/18/2013)

---

ScottPletcher (12/18/2013)

---

If your lookups will most often be by column2, you need to cluster the table on column2, or an encoded version of it, rather than...

Sigerson (12/19/2013)

---

Grant Fritchey (12/18/2013)

---

I could, but won't, argue that identities are a crutch. Natural keys can work fine. I try not to worry too much about the key structure while...

Jeff Moden (12/18/2013)

---

ScottPletcher (12/18/2013)

---

If your lookups will most often be by column2, you need to cluster the table on column2, or an encoded version of it, rather than having a...

I don't object to ISNULL() in the SELECT list, just in WHERE conditions. Since it shouldn't be used in WHERE, it's only consistent not to use it in IF...

I'm truly curious now:

Can anyone tell me:

Where "IS NULL" can't be used in place of ISNULL()?

Evil Kraig F (12/18/2013)

---

Scott,

I'm not sure how that's more or less obscure, but it's certainly easier for me to read. I work with a lot of 'iffy' data in...

Lynn Pettis (12/18/2013)

---

ScottPletcher (12/18/2013)

---

Lynn Pettis (12/18/2013)

---

Lynn Pettis (12/18/2013)

---

Luis Cazares (12/18/2013)

---

ScottPletcher (12/18/2013)

---

Better to avoid ISNULL, since you should never use it in a WHERE clause. I also think that exactly...

Lynn Pettis (12/18/2013)

---

Lynn Pettis (12/18/2013)

---

Luis Cazares (12/18/2013)

---

ScottPletcher (12/18/2013)

---

Better to avoid ISNULL, since you should never use it in a WHERE clause. I also think that exactly what's being tested...