Browse by Tags

Why read uncommitted data?

Published 19 December 6 10:0 AM | Ramon Smits

I just read Dennis post about his adventures in isolation level land . He says he does not know a good reason to read uncommitted data because of dirty reads. Well he should refrase this like: Using the isolation level read uncommitted data could result...

Filed under: .Net, Design, Transactions, Database

Change mssql isolation level to read uncommitted data

Published 29 September 6 2:43 PM | Ramon Smits

Sometimes you are debugging an application and want to query the database while the database connection still has not committed (or rollbacked) the transaction. So you fire up the query analyzer just to find out that you cannot see the modifications yet...

Filed under: Development, Transactions, MSSQL