You work in a company which is named Wiikigo Corp. The company uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. There is a report which is often executed during business time. There is a stored procedure that is used as the data source for the report. You get a report from users saying that they receive the data returned by the report but the data is inconsistent. As the technical support, you check and find that phantom reads cause this problem. You must make sure that consistent data is returned by the report while not affecting other users. So what action should you perform to achieve this goal?()
- A、You should configure the database for Read Committed Snapshot isolation.
- B、You should modify the stored procedure to use the Snapshot isolation level
- C、You should configure the database for Auto Update Statistics asynchronously
- D、You should modify the stored procedure to use the Repeatable Read isolation level
正确答案:B
答案解析:有
微信扫一扫手机做题