Summary

In this chapter, you learned how to use SQL Query Analyzer. This is an important tool that helps you to design, test, and tune a database in SQL Server.

The Object Browser helps you identify the definition of any object, without using metadata stored procedures or external tools. Using drag-and-drop helps you avoid misspellings.

You learned how to use the scripting facilities of Object Browser and Object Search. Now, you know how to produce results in text, grid, or to a file, according to your needs.

As any client tool, you can manage connection settings that help you adjust the connection to the user requirements.

Query Analyzer is a powerful analysis tool that helps you understand how SQL Server executes queries. Graphical Query Plan ...

Get Microsoft® SQL Server™ 2000 Programming by Example now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.