PrepAway - Latest Free Exam Questions & Answers

What should you do?

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?

PrepAway - Latest Free Exam Questions & Answers

A.
Use a table variable.

B.
Use a temporary table.

C.
Split the update operation into small batches.

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


Leave a Reply