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 |
|
shaggy
Posting Yak Master
248 Posts |
 Posted - 2009-04-06 : 08:47:19
|
| Is it necessary to include rowlock hint for update / Delete statement.or In which Scenario should i include rowlock hint for update / Delete statement. |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2009-04-06 : 09:12:49
|
No.Are these question from an interview?
E 12°55'05.63"N 56°04'39.26" |
 |
|
|
shaggy
Posting Yak Master
248 Posts |
Posted - 2009-04-06 : 09:32:57
|
| Thanks Pesothis is not an interview question.in our environment in many places i can see rowlock hint for update/delete.Iam surpised to see locking hint.I need proof to raise this issuse so if anybody provide some links it wil very useful. |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2009-04-06 : 13:08:05
|
You can only suggest for SQL Server which level of lock to begin with.SQL Server will esacalate to for example TABLOCK even if you have hinted with ROWLOCK, if SQL Server finds it necessary.
E 12°55'05.63"N 56°04'39.26" |
|
|
|
|
|
|
ROWLOCK for update