which one is correct. !

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Noor (noor_at_ngsol.com)
Date: 08/25/04 

Date: Tue, 24 Aug 2004 23:17:10 -0700

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

Relevant Pages

  • Re: Identity Column
    ... the end use is using Crystal Reports - where is the magic? ... The user will connect using Active Directory from their desktop to the database server or do please explain the magic.... ... Using stored procedures you permission on the stored proc only; the user can only execute the stored procedure with the parameters defined, there is no select * from to get all the information in your database. ...
    (microsoft.public.sqlserver.programming)
  • Re: Faircom c-Tree Server vs. Relational DBMS
    ... Our products were very reliable in terms of how the database ... SQL was used for building and upgrading the ... to process reports that take several hours to run. ... what database tools to use) that are dictated by management ...
    (comp.databases)
  • Re: Serious errors with Create view command
    ... the database is opened? ... There's no database on earth that behaves that way! ... What on EARTH does the option of 'Edit Stored procedures' do? ... I can't paste it INTO the view designer sql view ...
    (microsoft.public.fox.helpwanted)
  • Re: Transaction Oriented Architecture (TOA)
    ... OOP is not required to wrap SQL. ... of stored procedures to act as an API for application programmers ... writing code against the database. ... With a well-defined API in place, ...
    (comp.object)
  • Re: How to import/export D3-NT data to MS SQL?
    ... dumb dumb dumb dumb dumb ... They had a million donar database and a 1.5M donation ... Every night they were trying to update SQL with the data from ... We are using Crystal Reports ...
    (comp.databases.pick)