Can you post the execution plans?

It does sound like you need a covering index. A key lookup can be very expensive.

Hey Gail,

I see you suggested turning the safeties off to my bestest friend. Holy cow! Triggers calling unsafe CLR code. That ought to be entertaining. Some consultant somewhere is going...

Amol.Naik (1/14/2009)

---

Grant,

The Primary Key clustered index is infact defined on the TokenNo VARCHAR(25). Tokens used to be 25-digit codes earlier, but now they are 12 digit. These are guaranteed to...

bdgenterprises (1/14/2009)

---

Aaahhh, that is so stupid of me!!

Thank you very much. I couldn't see the forest from the trees. That was supposed to be 510, not 10.

Thank you very much!...

I guess I'm lucky. I've only had it lock up the system once. You guys ought to post your experiences over at the Red Gate forums. They'd be interested to...

I agree. SQL Prompt works better in lots of ways. That's before we talk about formatting your code for you... Woo Hoo!

You can manage 2005 servers from the 2008 interface (and 2000 servers, not 7.0 or 6.5).

Intellisense will only work on 2008 instances. Sorry.

Check out Red Gate's SQL Prompt. I...

Hey, AdventureWorks is my friend. Without it I'd have to create a fake database as well as fake queries for the book.

There's cool stuff on Codeplex. Nose around a bit.

CodePlex

All the good Microsoft examples are up there. This might be it.

Thanks Steve,...

Jack Corbett (1/14/2009)

---

Seems to be the week for folks like that. I don't think you were bad in your response either. I always try to at least be...

Instead of rolling your own cache management, you might consider one of the cache management softwares that's available. One of our systems under development has just started this process. Here's...

Clearly, I am as well.

Well, I just popped off

http://www.sqlservercentral.com/Forums/Topic635918-149-1.aspx?Update=1

Evidently I'm only providing problems, not solutions.

foxjazz (1/14/2009)

---

Ok, instead of giving me problems, how about providing a solution.

These tables are not (data) are not changed frequently, and the data is cached on the clients software.

When the...