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.
