Saravanan T (3/3/2010)
Hi ,My question is can i update the same table like below in another session....without commiting or rollbacking the session 1.
update tabb1 set c2=22 where c1=2
Just imagine the rows are in different page!!
In my previous answer I wrote you few things that can cause an open transaction to block an update statement on the same table but on different rows that are located on different pages. From that you can understand that it can happen. Of course it doesn’t mean that each open transaction will block every operation that effects different rows on different pages, it just mean that it can happen that it depends on few factors.
Adi
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/