Users frequently update millions of rows in a table at a time. Users report that it takes a long
time to update the rows. You need to recommend a solution to reduce the time it takes to
update the rows. The solution must be developed in the minimum amount of time. What
should you do?

A.
Use a temporary table.

B.
Split the update operation into small batches.

C.
Use a table variable.

D.
Use the NOLOCK optimizer hint and use a single transaction.