Thanks. Looks like this is the URL template to use to find a post by number:

http://www.sqlservercentral.com/Forums/FindPost831649.aspx

I can't review this now, but did you try the version of code I provided on the other post you had for this?

select itemid

,max(case eventtype when 1 then...

I seem to be unable to locate said post. Anyone...

Jeff Moden (12/8/2009)

---

I have two recommendations on that, Clive... first, post your question as a new post on the T-SQL forum because it'll will like get a better response there...

1) while loop is not a replacement for cursor. both are row-by-row processing.

2) if you ARE going to use a cursor, please declare it either FAST_FORWARD or READ_ONLY STATIC...

1) the primary key 'scan': I will bet that your PK is an identity integer with clustered PK? In any case, the clustered index scan is actually a table...

I will be there are other reasons cache hit ratio is poor. I also bet there are other performance-related problems here too.

Paul White (12/5/2009)

---

Hey guys,

I got a fantastic response to the connect item I filed concerning the collation performance thing. Check it out at http://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=512459

Extract:

Jim Hogg MSFT

---

I have assigned this...

shannonjk (12/4/2009)

---

So I managed to get this refactored finally, other critical projects took priority!

I managed to squeeze the script down to 1 CTE and its subsequent Select statement. The high...

Dave Mason (12/4/2009)

---

[font="Arial"]I prefer to avoid the IF/ELSE scenario for queries. Eventually, you'll have to "fix it" in two places. Plus, you open up the possibility of two...

In this case that is by far the best solution: simple, maintainable, and most important gets you the optimal plan for either...

Thought Pork Chops were your thing?? :hehe:

Jeff Moden (12/3/2009)

---

TheSQLGuru (12/3/2009)

---

Jeff, you silly person! My big smiley indicated that my pushing R2 was a JOKE. 🙂 I think it is in CTP3 stage or...

Tim - some questions shouldn't be asked!! 😀

Jeff, you silly person! My big smiley indicated that my pushing R2 was a JOKE. 🙂 I think it is in CTP3 stage or so ... ...