Showing related tags and posts accross the entire site.
-
unique constraints are very common for database table designs in applications nowadays. there are two ways to safely code an application to cater for this unique constraint requirement. (1) do an existence check/query before doing the insert. (2) let the database throw a unique constraint and handle...
-
Knowing the scenarios involved with the different Isolation Levels for SQL Server, I was surprised to find out a number of stored procedures being used in a project I'm involved with, has retrieval operations with a NOLOCK switch. I was searching for answers why they have designed the said SPs that way...
-
Sahil and Bill are having funny conversations on real life meaning of concurrency violations. You might want to peek here .