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 |
|
nomikhanxyz
Starting Member
6 Posts |
 Posted - 2013-06-27 : 08:42:47
|
| What, if any, locks does a SELECT statement place on tables, assuming the transaction isolation level is set to Read Committed. If it does place a lock, what is the effect of that lock? please if can someone Explain in detail with an example. Thanks in advance. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-06-27 : 11:01:34
|
| SELECT places shared locks on objects and holds it until reading of data is over. it may block other DML statement as well as select statements until it completes read. By using SNAPSHOT ISOLATION you can avoid it from locking other select queries though.------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
 |
|
|
Lamprey
Master Smack Fu Yak Hacker
4614 Posts |
Posted - 2013-06-27 : 11:06:49
|
quote:
Originally posted by visakh16
By using SNAPSHOT ISOLATION you can avoid it from locking other select queries though.
At a cost of higher IO. :) |
|
|
|
nomikhanxyz
Starting Member
6 Posts |
Posted - 2013-06-27 : 11:21:45
|
| First of all thank you very much for your response I am still confuse or in the middle ,so in case What is the effect of setting the transaction isolation level to Read Uncommitted? if its is higher IO cost.. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-06-27 : 11:56:33
|
| Read Uncommitted is different from SNAPSHOT ISOLATION.Read Uncommited is least restrictive of locking modes where you will even have access to data used by uncommited transactions which may cause dirty reads (if transaction rollsback later). SNAPSHOT ISOLATION will give you a read only copy of data as that existed before start of current open transactions------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
|
|
|
|
|
|
transaction isolation level is set to Read Committ