SQL Server Query Analyzer

SQL Server Query Analyzer is a graphical user interface for designing and testing Transact-SQL statements, batches, and scripts interactively. It can be called from SQL Server Enterprise Manager.

SQL Server Query Analyzer offers the following features:

• Free-form text editor for keying in Transact-SQL statements.
• Color coding of Transact-SQL syntax to improve the readability of complex statements.
• Results presented in either a grid or a free-form text window.
• Graphical diagram of the showplan information showing the logical steps built into the execution plan of a Transact-SQL statement.

  This allows programmers to determine what specific part of a poorly-performing query is using a lot of resources. They can then explore changing the query in ways that minimize the resource usage while still returning the desired data.

• Index Tuning Wizard to analyze a Transact-SQL statement and the tables it references to see if adding additional indexes will improve the performance of the query.

See Also