You discover that the usp_GetOrdersAndItems stored procedure takes a long time to complete while usp_AddOrder or usp_AddXMLOrder run.
You need to ensure that usp_GetOrdersAndItems completes as quickly as possible.
What should you do? (Each correct answer presents part of the solution. Choose all that apply.)
A. Set the isolation level of the usp_GetOrdersAndItems stored procedure to SERIALIZABLE.
B. Execute the ALTER DATABASE Sales SET ALLOW_SNAPSHOT_ISOLATION ON statement.
C. Set the isolation level of the usp_AddOrder stored procedure to SERIALIZABLE.
D. Set the isolation level of the usp_GetOrdersAndItems stored procedure to SNAPSHOT.
E. Set the isolation level of the usp_AddOrder stored procedure to SNAPSHOT.
F. Execute the ALTER DATABASE Sales SET ALLOW_SNAPSHOT_ISOLATION OFF statement.
