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

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

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