Advanced Querying and Query Tuning in SQL Server 2000 and 2005

This full-day seminar covers tuning in SQL Server 2000 and 2005. It presents a methodology for database tuning in general, and then focuses on T-SQL and query tuning specifically. Among the topics that will be covered in this seminar:

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.

As time permits, the seminar will also covers key querying techniques and their applications in solving common problems.

You will be introduced with polished techniques to solve complex querying problems, and learn how to optimize and tune your solutions.

Focus will be given to the new T-SQL features in SQL Server 2005, but the seminar will cover solutions in SQL Server 2000 as well.

To book a place fill out our registration form or call Tony Rogerson on 01582 768450 or email him at tonyrogerson@torver.net. There are discounts for block bookings.