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,
Affect on Performance,
Index Optimization Scale,
Partitioned Tables and Indexes,
Analyzing Query Performance,
Tools to Analyze Query Performance,
New Optimization Techniques,
Compilations and Plan Caching,
Performance Aspects of Programmable Objects,
User Defined Functions,
Querying System Catalog,
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 firstname.lastname@example.org. There are discounts for block bookings.