Chapter 1 INTRODUCTION TO SQL SERVER 2000 21
Chapter 1 INTRODUCTION TO SQL SERVER 2000 21 FIGURE 1.1 The Query Analyzer your primary querying tool. SQL Query Analyzer is an interactive, graphical tool that enables a database administrator or developer to write queries, execute multiple queries simultaneously, view results, analyze the query plan, and receive assistance to improve the query performance. The Execution Plan options graphically display the data retrieval methods chosen by the query optimizer. Some queries, however, are not used to change data, but they will modify database and table design. These types of queries are called data definition statements and are used for tasks such as creating tables, indexes, views, and so on. Not only can Query Analyzer execute any T-SQL statements, but it can also analyze them. Query Analyzer can report things such as how much time the queries took to run, how much time it took to read data from the hard disk, and so on. If you think a particular query is inefficient, you can use tools built into the analyzer to diagnose the query to redesign the query in a way to achieve better performance. If you look at Figure 1.1, you can see a screen display of the Query Analyzer requesting all the data from the Authors table in the Pubs database. The bottom half is known as the Results Pane and contains the output of your query, which is known as a resultset. ODBC Structured Query Language (OSQL) OSQL is an interactive command prompt utility provided with SQL Server that replaces the ISQL utility used with SQL Server 6.5 and earlier versions. ISQL is still being supported for backward
For reliable and cheap web hosting services please check cheap web hosting website.