1.  Explain in detail at least three (3) SQL Server query optimization tips and under what conditions they might be implemented.


Explain in detail at least four (4) performance tuning tips.  What are the reasons for implementing each of the tuning methods you report on.

Note: first Question Need Three Paragraphs(200-300 words) and references with APA format NO Plegarism

2.  What are wait types and what information do they provide for performance monitoring?

3.  What information does sp_who and sp_who2 provide for performance tuning analysis and how could the information be used?

4.  What is the statistics profile, what is it used for, what columns might be more useful than others?

5.  What is this view useful for monitoring?

6.  What does the index scan cost tell you?