Stuck with 

1. deadlocks
2. concurrent inserts
3. insert updates and select on single table from multiple sources?

Read this for comprehensive understanding

http://michaeljswart.com/2011/09/mythbusting-concurrent-updateinsert-solutions/