SQL Server 2005/2008 Internals and Query
Tuning
This is an advanced 5-day course designed for advanced
SQL Server professionals. The course includes extensive demonstrations that
illustrate the details of SQL Server internals as well as tuning techniques.
This course will be presented on SQL Server 2008 and cover features specific to
that version, but most of the information is relevant to SQL Server 2005 as
well. This 5-day intensive seminar was developed by one of the world's leading
experts in SQL Server internals. Topics to be covered include the following:
- SQL Server Architecture and Metadata
- Physical Storage Structures
- Index Design and Tuning
- Query Processing and Query Plans
- Optimization and Recompilation
- Concurrency Control: Locking, Blocking and Row Level
Versioning
- Query Tips and Techniques
- Troubleshooting Tools
The course includes extensive demonstrations that
illustrate the details of SQL Server internals as well as performance tuning
techniques. A reference CD including all of the demonstration scripts as well
as dozens of whitepapers and useful tools will be distributed at the end of the
week.
