This Tag is for SQL Server 2008 R2, major build version 10.50.xxxx

learn more… | top users | synonyms

10
votes
1answer
883 views

SQL Server 2008 R2 Dirty reads - how non-atomic?

I am wondering "how dirty" dirty reads can get under a read-uncommited isolation level. I understand that rows that have been updated but not yet committed are visible, but: Can a row appear as ...
1
vote
1answer
118 views

Sessions, Processes, Object Instances, Sequential and Parallel Processing Theory

A stored procedure contains a view which is accessed multiple times with the confines of the SP. If the SP is executed multiple times in one query window with different parameters, e.g. EXEC spMySP ...