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 |
|
rajesh_DBA
Starting Member
2 Posts |
 Posted - 2007-07-17 : 04:50:01
|
| hi i m rajesh..can any one exemplifiy the Row lock...?And in which scenario we need to use this?Thanks in advance |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-07-17 : 13:17:31
|
| Row lock is putting lock on single row. |
 |
|
|
dinakar
Master Smack Fu Yak Hacker
2507 Posts |
Posted - 2007-07-17 : 13:20:07
|
| And, generally, you dont need to use it. SQL Server does a pretty good job of maintaining locks. Sometimes, SQL Server escalates rowlocs to Table locks, called Lock escalation, leading to blocking etc. So you have to consider it carefully if you want to impose rowlocks.Dinakar Nethi************************Life is short. Enjoy it.************************http://weblogs.sqlteam.com/dinakar/ |
|
|
|
rajesh_DBA
Starting Member
2 Posts |
Posted - 2007-07-18 : 00:50:51
|
| yes i understood..thank u friends |
|
|
|
|
|
|
Rowlock???