You are a database developer. You create a database by using SQL Server 2008 in an
enterprise environment. The database contains two stored procedures named ModifySales
and RetrieveSalesTrend. The ModifySales stored procedure uses a transaction that
updates a table named SalesOrders. The RetrieveSalesTrend stored procedure retrieves
and aggregates data from the SalesOrders table for a sales trend analysis report. Both
stored procedures are executed frequently each day. Users report a considerable wait time
while they run the sales trend analysis report. You need to ensure that sales trend analysis
report runs as quickly as possible. What should you do?
A.
Change the isolation level to SERIALIZABLE for ModifySales.
B.
Change the isolation level to READ UNCOMITTED for ModifySales.
C.
Add the NOWAIT hint to the SELECT statement in RetrieveSalesTrend.
D.
Add the NOLOCK hint to the SELECT statements in RetrieveSalesTrend.