Michael Valentine Jones (2/18/2008)

---

You might try creating the index I suggested as non-unique to cover the query. It lets SQL Server treat the index like a table without a...

Michael Valentine Jones (2/18/2008)

---

Here are a couple of suggestions you could try.

Change the query in your fucntion to this. I think is is also logically better, because it prevents...

Jeff Moden (2/18/2008)

---

The fact that the UDF is taking longer than the embedded code is normal... there's a bit of an overhead associated with running UDF's in many cases especially...

On reversing the order, the function at times takes 0 sec. for a sample of 5 test runs the UDF takes 16 ms in 2 tests and 0 secs in...