If you're looking at the Data Explorer and the event you're looking at is database_xml_deadlock_report, it's going to just have an XML output. You can open that as you've seen...

Prediction? No. But following coding best practices to write queries such that they access objects in the same order, that they don't have major performance issues, that they use indexes...

Please don't cross post questions to multiple forums. It just confuses the discussion.

Gail, I said the same thing on the other one.

Sounds like you need to do what it suggests, start the process over again. Be sure that the FULL BACKUP you're restoring is linked to the DIFFERENTIAL you're restoring.

First, follow the suggestion and increase your max worker threads. That will both alleviate the issue and make it worse at the same time. It sounds like your system has...

Don't run DBCC checks hourly. That's a very serious load on the system.

Since you've never run the consistency checks, I'm with Gail, let them run no matter how long it...

The entire idea behind backups is to have a complete copy of the database. A restore operation also is a complete copy of the database. This is not an import/export...

But if the permissions were different, you'd get an error, not just disappearing comments. Are the schema's different or missing? Are you putting the comments within the procedure definition or...

I've put SQL Server compressed backups with non-compressed backups, script files, all sorts of things. It's just a file. I can't tell you that I have specifically put it on...

And no one has even mentioned DISTINCT yet.

Everything Luis says plus...

You have functions all over the place in your JOIN and WHERE criteria. These are going to absolutely prevent the use of statistics causing the execution plans...

It sounds like you're getting a parallelism deadlock. Hard to say for certain without seeing the deadlock graph.

Just because you see indexes in the execution plan doesn't mean they're...

I'm with Sean. It sounds like you're not running the ALTER PROCEDURE script but instead you're executing the procedure itself. Those are two distinct steps.

Troubelshooting SQL Server [/url]is a great book.

For just general administration, I wrote part of a book.

Cost Threshold for Parallelism

You change it as...