SQL Server deadlock analysis and prevention

Explanation was so clear and useful. It is the information I was actually looking for.

Thank you, but what to do when there is a deadlocks on different tables at update statistics at always on?

ليش مايكون عربي الشرح

your all videos are perfect to under stand SQL server

Can a deadlock victim be a select into temp table from view? because for us deadlock transaction 1. is to get a view and insert to temp table ,2. is to a update the table. and victim is shown as process id for view!!

I have a question regarding the second transaction, does it start execution after transaction 1 gets committed?

keep it up!!!

excellent!!

Belle réalisation !

I am sitting with this exact same situation, except the deadlock transactions are two select statements trying to read from the same table... I don't understand why a select would require an exclusive lock on a table...

Very cool. Thanks

Great stuff Sir. I do like to watch your training videos.

Thanks Venkat..............Its Awesome explanation

Nice...elb

Simply great!

Thank you very much, sir.

Can you please make project oriented tutorials on sql..

For U for all your job you have done. Great videos !

Perfect and CLEARLY explained as always... Thank you Venkat