Based on the following query:

SELECT CAST (

REPLACE (

REPLACE (

...

Ok will do

here is an example graph

Deadlock encountered .... Printing deadlock information

Wait-for graph

Node:1

KEY: 7:72057594123321344 (91002937eff3) CleanCnt:2 Mode:U Flags: 0x1

Grant List 1:

Owner:0x000000009566DB00 Mode: U Flg:0x40 Ref:0 Life:00000001 SPID:51 ECID:0 XactLockInfo: 0x000000022E5C43F0

SPID: 51...

Thanks reading it now.

GilaMonster (7/31/2012)

---

No need for a trace. On SQL 2008 deadlock graphs are written into the extended events system health session.

Post the deadlock graph here, we can give you some suggestions...

awesome thanks

I did the shrink and everything looks good. It was a runaway query that i'm hoping i learned my lesson. I appreciate all your help. Thank you.

When i ran

SELECT

db.[name] AS [Database Name]...

awesome thanks all, as usual great source of help and information

awesome information, being that we have a simple recovery model would it be safe then to shrink the ldf? its 50gb which seems really large especially based on the information...

awesome query, it says recovery model is SIMPLE. What does that mean?

MyDoggieJessie (11/8/2011)

---

If you have a database with Bulk/Full logging enabled you should schedule transaction log backups to run regularly, this will help keep them clean so-to-speak. If you haven't...

that stinks, but thanks for all you help very informative as usual

that link seems to be down but i did google based on the information and got this link

http://sqlserverpedia.com/blog/sql-server-bloggers/in-exists-and-join-%E2%80%93-a-roundup/

Where he found:

My conclusion from earlier posts stands. If all you...

I will thanks for the help, i'm reading the article and will need to figure out a good time to run the trace without effect production to much.