SQL Query Analyzer is not only a client tool to edit SQL queries and to show the correspondent results. SQL Query Analyzer provides analyzing capabilities that can help tune our databases and the queries they have to answer.
Analyzing queries is an advanced task, but it is important to at least show the very basic analyzing tasks every programmer should know.
The first question about query execution is usually: How long will it take to execute?
To answer this question, you can execute the SET STATISTICS TIME ON statement, or you can use the connection properties page and check the Set Statistics Time check box. Programmers can use these results to compare different strategies to retrieve ...