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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2000-10-11 : 09:21:12
|
| This must-read article, by Michael Balloni, discusses how SQL server locks tables and rows when UPDATE statements or SELECT statements occur. In a heavily hammered database, these locks can lead to slow performance and database errors. Michael also discusses two query-level locking options - NOLOCK and ROWLOCK - that can be used to give SQL Server some hints on how to deal with locking... which can dramatically increase your database's performance! A must read for those who run data-driven Web sites! Article Link. |
|
|
|
|
|
Article: SQL Server Lock Contention Tamed: The Joys Of NOLOCK and ROWLOCK