You are the administrator of a SQL Server 2000 computer. The server
contains two databases. A client/server application accesses one of the
databases. A different client/server application accesses the other
database. Each application uses several stored procedures to query and
update its database. Users report that both applications respond slowly. You use SQL Profiler to monitor activity on the server. You receive results of the trace as shown below:



You need to improve the performance of the applications. What should you
do?

A. Modify the applications so that they use views to query data.
B. Modify the stored procedures so that they select data into temporary tables.
C. Re-create the stored procedures so that they do not contain the WITH RECOMPILE option.
D. Disable the 'Autoupdate statistics' option in both databases.

Answer из Testkinga : B
Explanation: We see that the same data is queried in two separate statemants. This could result in locking and degraded perfomance. By usuing temporary tables, when appropriate like in this scenario?, the locking could be decreased and same data could be re-used. Both these benefits would impove perfomance.

Непонятно : в трассе я вижу обновления таблиц, как использовние временных таблиц может помочь? Предлагается скопировать эти таблицы во временные, то есть в tempdb и там с ними работать
A и D - тоже не подходят
следовательно С - но нет данных по Buffer Manager - Procedure cache pages и SQL Statistics - SQL Compilations/sec