Reputation
Top tag
Next privilege 125 Rep.
Vote down
Badges
2
Newest
 Teacher
Impact
~7k people reached

  • 0 posts edited
  • 0 helpful flags
  • 0 votes cast
Mar
5
awarded  Teacher
Mar
5
awarded  Autobiographer
Mar
5
comment How to make sure that simultaneous INSERT and SELECT on one table won't make a deadlock?
@alex - given default locking, how would a dirty read occur? You would have to specify that you're OK with dirty reads (aka NOLOCK).
Mar
5
answered How to make sure that simultaneous INSERT and SELECT on one table won't make a deadlock?