SQL Server 2008 Concurrency Problems and Isolation(technotes.towardsjob.com)

submitted by nitinkumarbenitinkumarbe(175) 2 years, 8 months ago

Concurrency problems SQL Server transaction isolation solves four major concurrency problems Dirty read occur when a reader reads uncommitted data Unrepeatable read occurs when existing row change within a transaction Lost updates occur when two writers modify the same piece of state Phantoms occur when new rows are added and appear within a transaction Locking strategies Optimistic concurrency

add a comment |category: |Views: 3

tags: another

new Add a live kick counter to your blog >> liveImage

You can even customize the image by choosing your own colors, and then clicking the button below to update the preview and the html code:

  • "Kick It" text
  • "Kick It" background
  • kick count text
  • kick count background
  • border

Simply copy and paste this HTML into your blog post.


Users who kicked this story:
Comments:

No comments so far

information Login or create an account to comment on this story