Jeff Moden (3/31/2010)

---

CirquedeSQLeil (3/30/2010)

---

Lynn Pettis (3/30/2010)

---

Jason, I read your blog post and I'm not sure what else I could add to your well written summary of the discussion we have...

That's the best way I know to handle it within the database. Just remember, if the error is of severity high enough to cause a disconnect, the CATCH can't catch...

Just taking a guess, there's probably something in the WHERE clause that's preventing you from getting the updates. But, as everyone else has said, without specifics, I'm just guessing.

However, it...

Part way there. That's the structure, but what do the queries look like? And what do the execution plans look like? Can you run this query against the table and...

david meagor (3/30/2010)

---

Grant, you have been most helpful and I appreciate the time you have spent replying to my issues.

If you pm me with your address I'll post you a...

Cause you're holding open a transaction on the client. As long as that's working that way, you'll be waiting.

BTW, you can get lots more information out of profiler besides RPC...

CirquedeSQLeil (3/30/2010)

---

I just realized one more complication with the review board. If the MVP were paid by Microsoft to be on this review board, then that person could no...

Code and structure are your primary points of pain when it comes to performance. Your structure needs to be laid out such that the code is facilitated with a good...

david meagor (3/30/2010)

---

Thanks. Just realized you have a book, I will buy and read once my panic is over!

I was looking at covering indexes yesterday, I have to admit...

Oh wait,...

At this...

david meagor (3/30/2010)

---

Thanks for all of your help so far. I think the cause has now been found. The error occurred twice more during the night and each...

Jack Corbett (3/30/2010)

---

Lynn Pettis (3/29/2010)

---

Here is what I think, before presenting anything to the PASS board, we really need to flesh things out more and put it in a more...

Jack Corbett (3/29/2010)

---

Okay, I had unsubscribed to this thread, but I got sucked back in. I have to admit that I have not read all the suggestions I had...

CirquedeSQLeil (3/29/2010)

---

Tough call. I was thinking volunteers because it could be more important to them in that fashion. However, their time is extremely important. Thus maybe they...