SQL Server Performance Forum – Threads Archive

TABLOCKX

is TABLOCKX/TABLOCK guaranteed?

---

THis is an exclusive lock, use it carefully otherwise nobody can guarantee the performance.
Check this link http://www.sql-server-performance.com/reducing_locks_hints.asp] for information. _________
Satya SKJ
Moderator
SQL-Server-Performance.Com

---

]]>