Advanced Querying and Query Tuning in SQL Server 2000 and 2005

Link para download http://www.sqlserverfaq.com/?eid=62

O seminário cobriu os seguintes tópicos:

Factors affecting query performance,
Tuning Methodology,
Indexes,
Affect on Performance,
Index Optimization Scale,
Fragmentation,
Index Enhancements,
Indexed Views,
Partitioned Tables and Indexes,
Temporary Tables,
Analyzing Query Performance,
Tools to Analyze Query Performance,
Query Writing,
Optimizer Enhancements,
New Optimization Techniques,
Compilations and Plan Caching,
Performance Aspects of Programmable Objects,
Stored Procedures,
Triggers,
Views,
User Defined Functions,
Concurrency,
New Isolations,
Row Versioning,
Troubleshooting,
Querying System Catalog,
Profiler,
Lock Hints.

Avaliação: