Optimizing Query Performance and Index Strategies

Overview/Description
Target Audience
Prerequisites
Expected Duration
Lesson Objectives
Course Number

---

Overview/Description
recognize how to optimize query performance and indexing strategies in SQL Server 2005

Target Audience
Developers who use Microsoft Office SQL Server 2005 and consultants providing consulting services for SQL Server 2005. individuals looking to pass the 70-442 PRO: Designing and Optimizing Data Access by Using Microsoft SQL Server 2005 certification exam and those individuals targeting toward the Microsoft certification: Microsoft Certified IT Professional (MCITP): Database Developer certification path

Prerequisites
Three or more years database programming experience including expertise in troubleshooting triggers, queries, stored procedures, user-defined functions, and user-defined types writing Transact-SQL queries, performing database performance optimization, designing and troubleshooting the data access layer of the application, designing databases, implementing databases at the physical level, and gathering business requirements

Expected Duration (hours)
2.2

Lesson Objectives

Optimizing Query Performance and Index Strategies

recognize how to evaluate the performance of a query and generate the execution plans.

recognize how to test a query and analyze its performance in SQL Server 2005.

recognize how to utilize specialized techniques to optimize queries, reduce their execution time and use the system resources efficiently.

recognize clustered, nonclustered, full-text, and XML indexes, and indexes with computed columns.

recognize how to create relational, XML and full-text indexes.

recognize how to optimize the performance of the indexes that are defined on your database table in SQL Server 2005.

assess query performance in SQL 2005 and determine performance improvement using Indexes and query optimization.

Course Number:
256874_eng