How does sql server decides which transaction is first and which one is the last if both happen at the same time -


i have basic question transaction - if 2 transactions different sessions start @ same time, 1 transaction has wait till other finishes. 1 of acid properties. question how system decide transaction first 1 , 1 has wait both transactions happen @ exatly same time.

right, not possible determine since sql server internal. see when there 2 processes accessing same table, once process declared dead lock victim while other executes. choosing process dead lock victim taken care sql server. believe might consider milli seconds or micro seconds difference between 2 processes , set priority.

hope helps!


Comments

Popular posts from this blog

javascript - Using jquery append to add option values into a select element not working -

Android soft keyboard reverts to default keyboard on orientation change -

Rendering JButton to get the JCheckBox behavior in a JTable by using images does not update my table -