To Set Deadlock Priority for Command or Query
performance #deadlock#performance
--add this line in the beginning of the command \ query set deadlock_priority deadlockvalue
--deadlock value rangle from -10 to +10
--ex: set deadlock_priority 9--add this line in the beginning of the command \ query set deadlock_priority deadlockvalue
--deadlock value rangle from -10 to +10
--ex: set deadlock_priority 9