Data Management

Microsoft T-SQL Performance Tuning Part 4: Analyzing and Optimizing T-SQL Query Performance on Microsoft SQL Server Using SHOWPLAN Output and Analysis

Vendor registration required

Executive Summary

This paper will teach you the basic techniques used to tune SELECT statements on Micosoft's SQL Server 2000 relational database management system. The paper will also teach you the techniques available using Microsoft's graphical user interfaces provided in Microsoft SQL Enterprise Manager or Microsoft SQL Query Analyzer, as well as using Quest Software's query tuning tools.

  • Format: PDF
  • Size: 335 KB