@ShadowWizard many, pulling chairs, putting pens under them, when somebody was going to sit, eating lunch of guys, hiding somebody's mobile or laptop and many more
@DroidDev oh, not nice! reminds me of a dog bite I got as a 10 years old kid, he got me right in the butt - worst part wasn't the bite itself but the anti rabies injections I had to get. Now that was painful!
I understand the differences between optimistic and pessimistic locking*. Now could someone explain to me when I would use either one in general?
And does the answer to this question change depending on whether or not I'm using a stored procedure to perform the query?
*But just to check, optim...