Question : I have a lot of threads that writing to DB some data in two tables. tbl_raw_data and tbl_parsed_data […]
Tag: isolation-level
Does ISOLATION LEVEL READ UNCOMMITTED affect Deletes?
Question : I have an exceptional circumstance that made me use SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED. (I am using […]
Does using a read committed isolation level and a NOLOCK query hint impact performance?
Question : Can having both the SET TRANSACTION ISOLATION LEVEL READ COMMITTED and WITH (NOLOCK) on all tables in SP […]
PostgreSQL Serialisation failure on different ids
Question : Serializable isolation mode can be used to avoid race conditions when upserting equal ids. So for create table […]
Dirty read or phantom row
Question : We are having dirty reads or phantom rows in our data warehouse. My question is not how to […]
Is the NOLOCK hint completely safe to use on a table that’s guaranteed not to change?
Question : If I have a table where the data is guaranteed to never change, is it completely safe to […]
PostgreSQL sometimes fails to detect serialization failures
Question : I have an http-server in application language that looks roughly like this: item = SELECT item FROM table […]
Benefits of SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED
Question : I use SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED in the majority of my general SQL queries, mainly because […]
Determining which isolation level is appropriate
Question : This is a homework question. For the following transactions state the isolation level that will maximize throughput without […]
Read Committed Shared Lock
Question : I wanted to know when you are at read committed isolation level and in one session someone started […]