I turned on profiler, looked at the vendor app and saw they're using a "rowlock" and an "index hint" for some "select" statements.. Read some about "rowlock"...is that a bad idea? client has reported some deadlocks so i was wondering.. thanks.
From BOL: The SQL Server query optimizer automatically makes the correct determination. It is recommended that table-level locking hints be used to change the default locking behavior only when necessary. Disallowing a locking level can affect concurrency adversely. What about long queries, and try to optimize those queries?. Execution plan, better indexes, etc. Luis Martin Moderator SQL-Server-Performance.com All in Love is Fair Stevie Wonder All postings are provided “AS IS†with no warranties for accuracy.
http://www.sql-server-performance.com/lock_contention_tamed_article.asp &http://www.awprofessional.com/articles/article.asp?p=27020 will help you. Satya SKJ Microsoft SQL Server MVP Contributing Editor & Forums Moderator http://www.SQL-Server-Performance.Com This posting is provided �AS IS� with no rights for the sake of knowledge sharing.
