Analyzing and Optimizing SQL Server 2000 Queries

Overview/Description
To show how to analyze and optimize queries

Target Audience
Database administrators, application developers, and system administrators; students preparing for Microsoft certification in installing, configuring, and administering Microsoft SQL Server 2000 Enterprise Edition

Prerequisites
Experience working in a medium to enterprise computing environment that uses SQL Server 2000 Enterprise Edition; at least one years experience administering SQL Server; at least one years experience implementing relational databases in environments that contain heterogeneous databases, SQL Server security integrated with Windows Authentication, client/server configurations of 50 to 50,000 or more users, web configurations that use Internet Information Services (IIS) or COM+, databases as large as 2 TB, and multiple installations of SQL Server 2000

Expected Duration
100 Minutes

Objectives:

Analyzing and Optimizing SQL Server 2000 Queries

  • analyze queries using the AND and OR operators.
  • analyze queries using JOIN operators.
  • optimize SQL Server 2000 queries.
  • analyze a query execution plan.
  • optimize query performance using the Query Optimizer.
  • develop an indexing strategy.
  • monitor and troubleshoot databases using SQL Profiler.
  • monitor database performance using SQL Profiler.


    • Course Number: 31920_eng