You need to ensure that the report returns consistent results without affecting other users

You administer a SQL Server 2008 instance.
A stored procedure is used as the data source for a report that is frequently executed during
business hours. Users report that the data returned by the report is inconsistent. You
discover that the inconsistencies are caused by phantom reads. You need to ensure that the
report returns consistent results without affecting other users. What should you do?

You administer a SQL Server 2008 instance.
A stored procedure is used as the data source for a report that is frequently executed during
business hours. Users report that the data returned by the report is inconsistent. You
discover that the inconsistencies are caused by phantom reads. You need to ensure that the
report returns consistent results without affecting other users. What should you do?

A.
Configure the database for Read Committed Snapshot isolation.

B.
Configure the database for Auto Update Statistics asynchronously.

C.
Modify the stored procedure to use the Snapshot isolation level.

D.
Modify the stored procedure to use the Repeatable Read isolation level.



Leave a Reply 0

Your email address will not be published. Required fields are marked *