Trying to find good book on concurrency

[dghundt]

I have been using visual studio 2005 C# and have been working with databases lately. I need a good read on updating data in mssql (for example) that gives a good practical lesson with concurrency which will allow me to safely update data with multiple database users. Thanks!

 

[mrdenny]

SQL Server is designed from the ground up to handle multiple users updating data at the same time. Standard update statements are all you need to use.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

My Blog

 

[dghundt]

Thanks for the information.

I have read that I need to setup optmistic concurrency o/w it is the last write who wins; everyone else is overwritten. There are features with optimistic concurrency that give notifications that the data was changed between reading it offline, and then updating it.

thanks

 

[ptheriault]

I have read that I need to setup optmistic concurrency

Are you creating your own database engine? SQL Server as well as any other RDBMS has already taken care of all that. If you want to use SQL Server then start here.

http://msdn2.microsoft.com/en-us/library/ms166019.aspx

- Paul
- If at first you don't succeed, find out if the loser gets anything.

 

[dghundt]

Thanks for the tip.
No, I will be using an already created sql2005 database.
I will browse your link. Thanks!