- Module 1: Describe SQL Server query plans
- Generate and save execution plans
- Compare the different types of execution plans
- Understand how and why query plans are generated
- Module 2: Evaluate performance improvements
- Explore Dynamic Manage Objects to extract query performance information
- Determine when changing indexes or defining new ones can affect performance
- Evaluate wait statistics as an aid in finding areas for performance improvement
- Module 3: Explore performance-based design
- Explore normal forms and how they affect database design
- Choose appropriate datatypes for your data
- Evaluate appropriate index types
- Investigate the value of data compression
After completing this module, you will be able to:
After completing this module, you will be able to:
After completing this module, you will be able to:
