A couple of things, have you looked at the execution plan? If you have and you don't understand what's happening there, save it as a .sqlplan file and post it....

A couple of ways that work pretty well. First, and this will work in 2000/05/08, is to use a sub-select with the TOP and ORDER BY operation like this:

SELECT ...

FROM...

I've gotten farther and farther away from enforcing naming standards. Too much time working with CRM, Sharepoint and ORM tools. Basically, I'd make the table names clear. Instead of tm_TableName...

It's best to try to avoid the whole arc relationship if you can. This is when you have a thing, Comment, that can be related to multiple other things, but...

Yepper.

Spam

Lynn Pettis (1/30/2010)

---

bitbucket-25253 (1/30/2010)

---

Lynn Pettis

Always thought that was a fallacy...

Paul White (1/29/2010)

---

It's a bit like SQL Server...

No, that was some seriously scattered questions & responses. I think a bit of the old hickory was needed.

The more code we post in the Thread, the sooner it achieves consciousness and...

jcrawf02 (1/28/2010)

---

ok, so SQL injection question - I understand that using sp_executesql with parameters will nullify the impact of SQL Injection commands, as the string is not directly executed. Gail...

And on a move that big, test your backups. Simply backing up is not enough. You need to know that they work.

Alvin Ramard (1/27/2010)

---

Lynn Pettis (1/27/2010)

---

Are you...

Yep, they can all run on the same machine without issue, except of course that they'll compete for the resources available on that machine.

Connection settings can be changed, independent of your database default connection settings. It's possible for the app to come in using serializable. I'd check the code if you're sure the...