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 |
|
nosepicker
Constraint Violating Yak Guru
366 Posts |
 Posted - 2005-03-24 : 17:56:59
|
| Is using "WITH (ROWLOCK)" an effective way to possibly reduce deadlocking that could occur with INSERT, UPDATE, or DELETE? Or would there be a noticeable cost with this method? Are there any other potential drawbacks with using this? |
|
|
MichaelP
Jedi Yak
2489 Posts |
Posted - 2005-03-24 : 19:07:53
|
| Generally, you want to avoid doing this. SQL Server will pick the most effecity lock to complete the task at hand. If anything, WITH (ROWLOCK) will cause more deadlocks than it solves.Michael<Yoda>Use the Search page you must. Find the answer you will.</Yoda> |
 |
|
|
nosepicker
Constraint Violating Yak Guru
366 Posts |
Posted - 2005-03-24 : 21:35:52
|
| Thank you for your insight. It is very helpful. |
|
|
|
|
|
|
with rowlock