KALPESH's Articles in Databases

  • Record Locking in SQL Server
    The SQL Server query optimizer automatically makes the correct determination. It is recommended that you do not override the choices the optimizer makes. Disallowing a locking level can affect the concurrency for a table or index adversely. For example, specifying only table-level locks on a large table accessed heavily by many users can affect performance significantly. Users must wait for the table-level lock to be released before accessing the table.

  Site Links We Support:
  Home
About Us
Contact Us
RSS Feeds
Privacy Policy
Terms of Service
Link Partners
 
 


**scoop**

Powered by Article Dashboard