O'Reilly logo

Microsoft® SQL Server™ 2000 Programming by Example by Carlos Eduardo Rojas, Fernando G. Guerrero

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required