Topics covered:
- Database Performance Factors
- Query Execution Plans
- Operations and Costs
- Table Scan
- Nested Loops
- Index Seek
- Clustered Index Seek
- Merge Join
- Hash Join
- Sort
- Hash Match
- Table Indexes - Clustered and non-Clustered Indexes
- Caching SQL Query Results
- Table Partitioning in SQL Server