You are a database developer. You plan to design a database solution by using SQL Server
2008. A database contains a table named Policies. The table contains information about
100 million insurance policies. A complex stored procedure executes daily to calculate the
risk amount of each policy and stores the information in the table. When the stored
procedure is executed, users experience poor performance and query time-out errors. The
queries used in the stored procedure are optimized for performance. You need to ensure
that the disruption to users is minimal while the stored procedure is being executed. What
should you do?
A.
Use the READ UNCOMMITTED transaction isolation level.
B.
Split the execution of the stored procedure into batches.
C.
Write the risk amounts to a table variable before you update the Policies table.
D.
Write the risk amounts to a temporary table before you update the Policies table.
Explanation: