Wow, thank you very much Ed, very helpful!

Thank you Jonathan!

Would love to hear back from someone who has experience with peer-to-peer. Thanks.

Many, many thanks!!! Great, in-depth explanation!

When I try to open the xdl file in SSMS 2012, I get:

Failed to initialize deadlock control.

Key cannot be null.

Parameter...

Thank you Jared.

Hi Jonathan, I read your article, but I am still unsure how to see the graphical view of the deadlock. The query returns several rows of xml data and...

Thanks to everyone for your helpful input!!

Chrissy, your solution is very interesting, but since our SP is quite large, it probably will have a very large, confusing call to the...

got it, many thanks!

Thanks! 🙁 Made a mistake at work by thinking that the whole batch is a transaction. Yikes. Good thing I test my backups regularly.

Many thanks for sharing the code Gianluca, it's great!

You can create a snapshot of the DB and run CHECKDB against that.

You could do a couple of things:

1. Run Profiler and trace the job.

2. Try running the steps from SSMS (if possible).

3. Create a "log" table and insert...

Hi Gila,

I don't think that this applies to my scenario. I have an index scan, which has an actual rows count of 50K, and an estimated count of...

Very interesting, thanks!

Many thanks to everyone for their informative suggestions, I learned a few things that I can always put to use!