You work as a SQL Server 2008 database administrator at ABC.com. ABC.com is using a SQL
instance that has a stored procedure which is used create a report. One day, a ABC.com user
named Mia Hamm complains that the data returned by the report lacks consistency. During the
investigation you notice that this is the results of phantom reads. You need to make sure that the
report resultsare consistent. Other database users at ABC.com must not be affected by your
solution.
How would you accomplish this task?
A.
You should consider creating an index on the columns used queried the stored procedure.
B.
You should consider having the stored procedure run in the Snapshot isolation mode.
C.
You should consider rewrite the stored procedure to use the columns suggested by the SQL
Server Profiler.
D.
You should consider changing the stored procedure to utilize the Read Uncommitted level.
Explanation: