• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 4. SQL Server Basics > Introduction to the Query Analyzer

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 the process of adding indexes will improve the performance of a query


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint