Alison Balter's Mastering Access 2002 Enterprise Development

Introduction to the Query Analyzer

The Query Analyzer is probably the second-most-used tool that ships with SQL Server (the first is Enterprise Manager). The SQL Server 2000 Query Analyzer is both robust and easy to use. Figure 4.25 shows the SQL Server 2000 Query Analyzer. This powerful tool provides a graphical user interface for interactively creating, running, and debugging T-SQL statements. The Query Analyzer allows you to:

• View existing SQL Server objects in an object browser

• View T-SQL in a color-coded environment

• Use templates to create T-SQL statements

• Execute statements from multiple connections

• Easily debug your stored procedures

• View a graphical diagram of your query execution plans

• Load the Index Tuning Wizard, a tool that determines whether ...