07-31-2023, 09:49 AM
My favorite use case for `read uncommited` is to debug something that is happening inside a transaction.
Start your software under a debugger, while you are stepping through the lines of code, it opens a transaction and modifies your database. While the code is stopped, you can open a query analyzer, set on the *read uncommited isolation level* and make queries to see what is going on.
You also can use it to see if long running procedures are stuck or correctly updating your database using a query with `count(*)`.
It is great if your company loves to make overly complex stored procedures.
Start your software under a debugger, while you are stepping through the lines of code, it opens a transaction and modifies your database. While the code is stopped, you can open a query analyzer, set on the *read uncommited isolation level* and make queries to see what is going on.
You also can use it to see if long running procedures are stuck or correctly updating your database using a query with `count(*)`.
It is great if your company loves to make overly complex stored procedures.