My guess, and that is about all I can give since you haven't really provided a lot of info, would be one of two things: Parameter sniff or stale statistics.

If...

You do realize since your routine is a multi-statement TVF that the Quesry Optimizer...

And a cannon to launch them, maybe?

Hey Steve,

Got some swag for the person who posts the 10,000 post on The Thread?

Post your code, maybe someone will be able to figure out what is wrong.

Alvin Ramard (12/11/2009)

---

Lynn Pettis (12/11/2009)

---

CirquedeSQLeil (12/11/2009)

---

By the time the thread hits 10,000 y'all will be flatlined, passed out drunk from all the bear being passed around - bwahahaha 10,000 shall...

CirquedeSQLeil (12/11/2009)

---

By the time the thread hits 10,000 y'all will be flatlined, passed out drunk from all the bear being passed around - bwahahaha 10,000 shall be mine (or anybody...

GSquared (12/11/2009)

---

On the subject of beer, one of my favorite jokes is that the human body is the world's most efficient machine at turning European beer into American beer. ...

Okay, so it gives an error. Care to share what that might be?

Actually,...

Merry Christmas and Happy New Year to you as well. May the holidays be good to you.

mahesh.vsp (12/11/2009)

---

If that is the case, tell me whether following thing works for side - by - side upgade?

1.Install SQL 2008 with SP1

2.Restore or overwrite the system databases. i.e. master,msdb.

3.restore...

May seem like overkill, but could you post the EXACT SQL code you are running?

Sometimes, you just have to question people.

The only blocking you should see would be the result of attempting to access rows that are being updated in that particular batch as long as it hasn't escalated to...