Thanks...

also be sure to output to text not grid!

I used a proc called NOW. not sure where I got it, but when you want to see all the queries that are on the server.. when the server...

We are going forward using BIGINT and using it for comparison purposes but storing it in other columns...

Thanks Ladies and Gents!

Still doesnt help with Milliseconds.

So basically I am SOL without 2008:(

I am looking more into what my customer needs this for. Just comparing, that would be find to compare...

We are not approved to move that server to SQL 2008.

awesome. I thought I was losing my mind.

I should of looked at BOL 1st.

But how to get around this? any way? I am dealing with a...

OK. Thanks for your help. I should see deadlocks tonight if it doesnt work. I will let you know. Thanks so much for your help!

Also keep in mind the main deadlocks I see are only invloving the deletes. not the update even though the update runs frequently it is not a node of the...

Ok. I have added the indexes. but the first one is a bit wide. I got the following:

Warning! The maximum key length is 900 bytes. The index...

No clue. I...

They are are an int with a current length of 6

Nope it is SQL_Latin1_General_CP1_CI_AS

GilaMonster (6/1/2010)

---

Where was the clustered index before you removed it?

Most of those nonclustered indexes are useless, they're too narrow. Other than the queries referenced in the deadlock graph, what other...

Brandie Tarvin (6/1/2010)

---

She's not asking for the log file. Do you know how to do a deadlock graph?

If not, let us know and we can walk you through it. If...