Finding and Fixing Bad SQL in Microsoft SQL Server 2000

This article will teach you the basic techniques used to find and fix poorly performing SQL statements (usually SELECT statements, but also INSERT, UPDATE and DELETE statements) on Microsoft`s SQL Server 2000 relational database management system.

We will teach you the techniques available using Microsoft`s native tools, such as Microsoft SQL Profiler, Microsoft Query Analyzer and Microsoft Performance Monitor.

We will then compare and contrast these techniques to Quest Software`s performance management and query tuning tools, Performance Analysis and SQL Tuning.