Excellent articles on SQL optimization. Cover a lot of territory. Contain good examples, screen shots, etc.
Topics include:
SQL Server Performance Tuning Part I
1- Profiler (trace)
How to set up traces
What to trace and why
2- Show Execution Plan
How to analyze the plan
3- Statistics IO
How to analyze
Definitions of terms
4- Identifying the Problem
SQL Server Performance Tuning Part II
5- Optimization Techniques
Avoiding redundancy
Avoiding cursors
Proper indexing including covered indexes
6- More on indexing
Clustered indexes
Avoiding functions in query criteris
Foreign key optimization
Criteria to avoid (Not In, count(*), etc.)
Update Statistics
Permanent tables vs. Temp tables
Denormalization
Article can be found at Terry L. Broadbent
faq183-874 contains some tips and ideas for posting questions in these forums. Please review it and comment if you have time.
NOTE: Reference to the FAQ is part of my signature and is not directed at any individual.
Topics include:
SQL Server Performance Tuning Part I
1- Profiler (trace)
How to set up traces
What to trace and why
2- Show Execution Plan
How to analyze the plan
3- Statistics IO
How to analyze
Definitions of terms
4- Identifying the Problem
SQL Server Performance Tuning Part II
5- Optimization Techniques
Avoiding redundancy
Avoiding cursors
Proper indexing including covered indexes
6- More on indexing
Clustered indexes
Avoiding functions in query criteris
Foreign key optimization
Criteria to avoid (Not In, count(*), etc.)
Update Statistics
Permanent tables vs. Temp tables
Denormalization
Article can be found at Terry L. Broadbent
faq183-874 contains some tips and ideas for posting questions in these forums. Please review it and comment if you have time.
NOTE: Reference to the FAQ is part of my signature and is not directed at any individual.
