Just to clarify, in the case of your query, where you are only using a single column as such in your subquery, the type of index - clustered or non-clustered...

You actually can't do what you are trying to do very easily. The problem is that when the variable comes in, it is not a list like you may...

I actually think the trigger is the way to go for a couple of reasons.

First, I don't see how you can do the logging without it. That's the big...

Based on the name of your column and the name of your table, this sounds like it should probably be the primary key. If it is, and has been...

You mentioned changing the level of parallelism. Are your queries being spread out across multiple CPU's? If this is an OLTP database (which it sounds like it is),...