You are a database developer for Wingtip Toys. The company tracks its inventory in a SQL server 2000
database. You have several queries and stored procedures that are executed on the database indexes to
support the queries have been created.

As the number of catalogued inventory items has increased, the execution time of some of the stored
procedures has increased significantly. Other queries and procedures that access the same information in
the database have not experienced an increase in execution time.

You must restore the performance of the slow-running stored procedures to their original execution
times. What should you do?

A. Always use the WITH RECOMPILE option to execute the slow-running stored procedures
B. Execute the UPDATE STATISTICS statement for each of the tables accessed by the slow-running
stored procedures.
C. Execute the sp_recompile system stored procedure for each of the slow-running procedures
D. Execute the DBCC REINDEX statement for each of the tables accessed by the slow-running stored
procedures

Думаю, что ответ C, т.к. A слишком категоричен :)