PLEASE PROVIDE SCREENSHOTS IF NECESSARY

2. In SQL Server Management Studio, construct a SQL query that uses a SELECT statement

and a JOIN clause to query data from both the Customer and Address tables. Analyze the

estimated execution plan.

a. Identify the most costly plan steps.

b. Are any of the steps that you identified in Step 2(a) a cause for concern? Explain.

c. Describe how the performance of the query could be improved, or explain why the

query is already optimal.

3. Implement any changes identified in 2(c) and execute the query using the option Include

Actual Execution Plan. Document this step by taking a screen shot of the actual execution

plan.

4. Use SQL Server Profiler to capture a trace and execute the query again. Analyze the trace

and determine how many milliseconds the query took to execute. Take a screen shot of the

trace that shows the execution of your query to document this step.

5. Launch the Database Engine Tuning Advisor from Query Editor to analyze your query. Did

the analysis generate any recommendations? Explain why or why not.

TABLES FOR PROBLEM

CustomerlD CustomerAddresslD CustomerName Westem Supply Company Nick Harper Alice Harper Abacus Consulting CustomerlD CustomerAddresslD CustomerName Westem Supply Company Nick Harper Alice Harper Abacus Consulting