Jim Russell (12/22/2008)

---

Thank you Grant!

Since I can't attach .sql or .sqlplan files here, I have attached a .doc file which attempts to capture my situation. And in the process...

I just zip them and attach them.

It looks like an audition for "Singing in the Rain"

AAAAAAAaaaaaa!

The primary key is the unique identifier in the table. That's it's primary purpose, a constraint on data so that each row is uniquely identified. However, it can also help...

As you've already discovered, it's possible. I'm not sure I'd recommend it though. Take the time & trouble to create the databases, keep them small and then copy and use...

Without at least an execution plan, we're just not going to be very specific in helping you.

Yeah, you might be accessing the clustered index, but you might not. It depends...

Also that it's going to the right database. I've seen the default database used and it isn't immediately obvious.

Paul (12/20/2008)

---

I'm not concerned about data accuracy in this system, so the NOLOCKs shouldnt be a problem. The main data is updated at infrequent intervals, and its not critical that...

It's either a really poorly written query or you have blocking. You need to look at, at least, sp_who2.

Also, can you get the execution plan? Query sys.dm_exec_query_plans if you can't...

And best practices dictate that you don't use them in user defined tables. Nothing prevents you from doing it, but it's generally considered poor design and can, in some cases,...

bitbucket (12/19/2008)

---

Grant

Good luck in that position. I...

Steve Jones - Editor (12/19/2008)

---

I'll stick to beer in my beer, no wheat, fruit, chocolate, etc. In fact, I had a very nice Corona with my brother-in-law to be last...

ALZDBA (12/19/2008)

---

Grant Fritchey (12/19/2008)

---

A LAMBIC!!!!!

DO NOT, I repeat, DO NOT, GO PUTTIN' FRUIT INTO MY GOL DURNED BEER.

Belgians... They get a couple of things right (double, triple, & saison (very...

I just installed it from a network share. Nothing special. I'm not sure if you'd have something different or not. Since it's automated, it could be the automation is incorrect....

I want to try this on my own, but I'm a bit busy. Has anyone tried querying sys.dm_exec_query_plan?