Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
stepcicc
Starting Member
2 Posts |
 Posted - 2011-02-09 : 02:21:47
|
| Hi. We have 3 applications that are constantly reading and writing to the same 4 tables in one DB. The information hat the applications require from the DB is completely separated ie App1 update or insert on the 4 tables will have no effect on App2 or 3.For example an insert from App1 would be something like:Insert INTO tblTest VALES(1,2,3) where AppKey = 1While App2 would at the same time also be doing and insert or a select:Insert INTO tblTest VALES(1,2,3) where AppKey = 2Select * FROM tblTest where AppKey = 2So my question is, is it safe to use NO LOCK option with my Insert and Update queries to speed thinks up because currently the locks are slowing things down? |
|
|
|
|
|
No Lock on Inserts and UPdate