FIX: You may experience concurrency issues when you run the DBCC INDEXDEFRAG statement in SQL Server 2000

When you run the DBCC INDEXDEFRAG statement, null mode page locks may accumulate on defragmented pages. These page locks may consume server resources. Then, the transactions that accumulate the locks try to escalate the page locks to table locks. The transactions escalate the page locks to try to re

Read More - Register for Free Membership