Analyzing Queries
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.
Obtaining Information About Query Execution
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 ...
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.
