The following question is taken from:
http://www.cram4exams.net.

I don't agree with the answer. I would like to post this
qustion for discussion.

Question
(5) You are a database developer for your company's SQL
Server 2000 database. You update several stored procedures
in the database that create new end-of-month reports for
the sales department. The stored procedures contain
complex queries that retrieve data from three or more
tables. All tables in the database have at least one
index.

Users have reported that the new end-of-month reports are
running much slower than the previous version of the
reports.

You want to improve the performance of the reports. What
should you do?

A. Create a script that contains the Data Definition
Language of each stored procedure. Use this script as a
workload file for the Index Tuning Wizard. B. Capture the
execution of each stored procedure in a SQL Profiler
trace. Use the trace file as a workload file for the Index
Tuning Wizard. C. Update the index statistics for the
tables used in the stored procedures. D. Execute each
stored procedure in SQL Query Analyzer, and use the Show
Execution Plan option. E. Execute each stored procedure in
SQL Query Analyzer, and use the show Server Trace option.

Ans:E

Why not B or C? Any thoughts?

Thanks,

Janie

Report this post to a moderator

"janie" <jzhao@tarrantcounty.com> wrote in message
news:008801c2e73a$f5900110$a50
1280a@phx.gbl...
> The following question is taken from:

.... a site that offers questions stolen from the live exams.

Sorry, I have no help available for that. Don't sell yourself short - I
doubt you need to cheat to pass this exam.

Report this post to a moderator