peter (1/10/2009)

---

My comments are focused on non-meaningful primary keys, which is what identity columns are. It is just a compact number (32 bit int in most cases) and contrary to...

peter (1/10/2009)

---

A primary key (identity or otherwise) cannot be used due to any sensible order by clause in the base query. Remember here that an order by on just the...

You are using CTE...

Adam Haines (1/7/2009) ...Unfortunately, this still should yield a index scan. The case expression is still evaluated for every row, as the optimizer doesnt know if the variable matches...

TheSQLGuru (1/7/2009)

---

phystech (1/7/2009)

---

No, zero length string plays the role of NULL. That is if...

I need a couple of days to prove/disprove it, right now I'm working on my...

No, zero length string plays the role of NULL. That is if the parameter...

TheSQLGuru (1/7/2009)

---

phystech (1/6/2009)

---

Adam Haines (1/6/2009)

The optimizer knows that

"CASE WHEN @FirstName IS NOT NULL THEN"

can be evaluated before the query is launched, since no column name is involved here...

Adam Haines (1/6/2009)

WHERE CASE

WHEN @FirstName IS NOT NULL THEN

CASE WHEN FirstName = @FirstName THEN 1

...

Adam Haines (1/6/2009)

---

phystech (1/6/2009)

---

What can we do to make this query index seek? Well, we really only have two options. One is to use dynamic sql to build...

What can we do to make this query index seek? Well, we really only have two options. One is to use dynamic sql to build the predicate dynamically....

John Magnabosco (8/25/2008)

---

In regard to the last line of the editorial: "I have no idea how to change this in the world at large, other than more emphasis throughout society...