As you've seen from some of the examples in this book thus far, the Query Analyzer is a handy tool that enables you to send queries to the database and display the results. This makes it an effective debugging tool, particularly in debugging queries embedded in stored procedures.
However, the Query Analyzer also offers several options that will help you to greatly increase the performance of your queries.
A note to more experienced readers: The Query Analyzer does things you should be doing anyhow… but if you haven't, it's a great way to get them done.
Before attempting to use the Query Analyzer, ...