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 |
|
nic
Posting Yak Master
209 Posts |
 Posted - 2006-07-07 : 17:47:47
|
| Hi,We have some data tables that are rarely updated (essentially the data is pretty static). Is there any benifit to adding NO LOCK/READ UNCOMMITTED lines to stored procedures that query from these tables?Since the data is only queried (i.e. SELECT), the table will never be locked so is there any added benifit? (maybe the way the sproc accesses the data is different if it knows it can be dirty reads?)Thanks,NicNic |
|
|
|
|
|
table locking