Ah sorry, different issue, different post. My mistake.

BTW, it's always helpful, but hardly necessary, that if you answer a question you posted, go ahead and post the answer. It'll not...

I don't have the answer, but you might want to post the question over in the 2008 forum. If people aren't monitoring both, they may not see this.

Also, if this question is related to this post:

http://www.sqlservercentral.com/Forums/Topic621088-145-1.aspx

You really shouldn't post multiple times because it just diffuses the conversation, making it harder for people to help and duplicating effort.

Simply updating 46 columns should not cause a deadlock. This would cause blocking, as one resource would have to wait on another while it's update completed. You have other processes...

Are these queries part of a bigger set of commands? Nothing there indicates why you'd receive a deadlock. You need to look at the statements prior to these two to...

Or edit the post... that works too.

Most of it is not displaying. You should try zipping it up and posting it as an attachment.

To add to what Gail says, I'd also suggest, that when you're not troubleshooting deadlocks, capturing the Start command is unnecessary. Usually getting RPCComplete and SQLBatchComplete covers just about everything...

You can use the OR construct or even COALESCE

WHERE SomeValue = COALESCE(@Param,SomeValue)

But the OR constract and the COALESCE construct aren't going to perform terribly well because either one will cause...

How are the slots defined? Is each one an hour? You can simply write a query that uses a parameter for the particular meeting hall and a parameter for the...

Couldn't help myself. I did a google search on the OP's name. He's an Access guy and, to his credit, has posted helpful answers to others in the forums where...

MGS (12/16/2008)

---

I would like to be able to create a foreign key reference in a child table to part of a compound primary key in the parent table. But I'm...

Usually I capture procedure calls using trace events and then you know which procedures on which databases are running long or using more cpu.

With 2005 & 2008, you can also...

But not deletion when the keys are in use, right?

Today you just want to find out which procs are hitting. Tomorrow you're going to realize that you can begin to run aggregates and groupings to put out more meaningful...