mourad.b (1/8/2013)

---

Well this is the situation, this is in my home lab and I'm looking to restore an SQl Express 2005 DB to a 2008 SQL server is possible using...

Please read through this - Managing Transaction Logs[/url]

rocky_498 (1/7/2013)

---

The Store Procedure "MyStoreProcedure" has 19 Pages hard to post here ( I hope you understand). Some time this SP work fine and Some time i am getting Dead...

Can you post the definitions for MyStoreProcedure and CM.dbo.saveCodedProcTx, as well as the indexes on the tables CM.dbo.tblEncounters and CM.dbo.tblCharge?

The entire deadlock graph. Just one of them if there are multiple.

Joie Andrew (1/7/2013)

---

Of couse these solutions are only good if SQL has not been restarted since the TempDB errors, as the DMVs will only collect metrics from the time SQL...

Someone ran a query that pulled a lot of data and put an order by on it (or something that required a...

Switch traceflag 1222 on. That will result in a deadlock graph been written to the error log every time a deadlock occurs. Post the result of that graph here.

DBCC TRACEON(1222,-1)

There's...

I did say "Usually somewhere around 0.1%-0.5%"

p.s....

My random wafflings on the subject: http://sqlinthewild.co.za/index.php/2011/11/11/sql-university-advanced-indexing-indexing-strategies/

Please post new questions in a new thread. Thank you.

Just a comment on your 'solution', you got lucky there, SQL cannot always recreate the log file if it's lost. It's very possible that deleting the log file will result...

Match all criteria, yes. What I was thinking...

The most selective one (the one that, based on...