Monday, August 24, 2015

What is chaos in isolation level options in SSIS?

"Chaos" - like "Read Uncommitted," permits viewing uncommitted changes, but without holding update locks until the end of transaction. Due to its lack of support on the SQL Server platform and inability to roll back, it is rarely used.

No comments:

Post a Comment