Viewing 5 posts - 31 through 35 (of 35 total)
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...
Tim Januario
February 15, 2010 at 6:28 am
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...
Tim Januario
February 13, 2010 at 8:48 am
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...
Tim Januario
February 13, 2010 at 8:31 am
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...
Tim Januario
February 13, 2010 at 8:19 am
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),...
Tim Januario
February 13, 2010 at 7:57 am
Viewing 5 posts - 31 through 35 (of 35 total)