Which of the following best practice should be carried out concerning data types?

A) Capturing SQL Server Deadlock Information in XML Format

B) Optimistic Locking in SQL Server using the ROWVERSION

C) Processing Data Queues in SQL Server with READPAST and UPDLOCK

D) Avoid using NOLOCK on SQL Server UPDATE and DELETE statements

Correct Answer : Optimistic Locking in SQL Server using the ROWVERSION

Explanation : Implementing optimistic locking utilizing the row version data type is an effective, low overhead way to prevent lost updates while still maintaining application concurrency.