Improving Your Queries with the SQL Query Analyzer
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, ...
Get Sams Teach Yourself ADO.NET in 24 Hours 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.
