ASFSDJG (9/7/2012)

---

If we force clustered index it is display all the columns .

select * from <table_name> with (index (cluster index name>)) where field_id = 2

its gets result.

Execution plan attached

SQL Kiwi (9/4/2012)

---

Blog post is up: http://bit.ly/ComputeScalar

Usman Butt (8/29/2012)

---

hahahaha..but your version too started with varchar(max) as the parameter, so would the explicit conversion to nvarchar(max) would have matter :hehe:

Usman Butt (8/29/2012)

---

1. Does Replacing an expression from varchar(max) takes less time than nvarchar(max)? I have seen this behavior many times.

Usman Butt (8/29/2012)

---

I do not know BWAA-HAAA!!!! is the right word to use here but using it anyhow.

SQL Kiwi (8/28/2012)

---

By the way, Oleg's XML function also fails when a semicolon is the delimiter and characters like '<' or '&' are present.

Jeff Moden (8/26/2012)

---

Ok... I tried those two. Why does the LEFT(@@Dbts,0) speed things up so much?

Jeff Moden (8/26/2012)

---

Ok... I tried those two. Why does the LEFT(@@Dbts,0) speed things up so much?