Summary

The SQL Server Query Analyzer has evolved into a fairly full-featured SQL development and analysis tool. It has a number of useful and advanced features that go beyond simply being able to edit and submit queries to SQL Server.

The SQL Server Transact-SQL debugger has been through a number of difficult-to-use implementations , but this time around Microsoft has a winner. The 2000 SQL Debugger is well integrated into the Query Analyzer application, and it is extremely helpful for debugging complex stored procedures, user -defined functions, or triggers. The debugger can still be somewhat difficult to configure properly, but after you have the right pieces in place, it is easy to use.

In the next chapter, "Using the SQL Server Profiler," you will read about ways to use SQL Profiler to monitor and capture the SQL and information about the SQL that is being submitted to SQL Server. If you identify any problem or poor performing queries in SQL Profiler, you can use the tools available in Query Analyzer to analyze and troubleshoot those queries.