magarity (12/22/2008)

---

Sorry, I don't...

I agree with the rewrites. The simpler and clearer you can make the query, not only will it be easier for you, and those that come after you, to maintain,...

All the basics work fine, no issues. Intellisense doesn't work. There are some other newer bits & pieces that won't work.

For what it's worth, it works well on SQL...

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...