Three important tools are now integrated into SQL Server 2000’s Query Analyzer. SQL Trace lets you trace code directly from a query window, without running the Profiler.

Click "Create a new instance of SQL Server, or install Client Tools" at the Installation Selection window, and click "Next." Click "Client Tools Only" at the "Installation Definition" window.

DBSophic is an innovative provider of performance management products for SQL Server based applications. While traditional SQL Server tuning tools focus on individual query optimization, DBSophic ...

FMS is now shipping the first release of Total SQL Analyzer, a documentation tool for SQL Server. Supporting SQL Server 7.0 and SQL Server 2000, Total SQL Analyzer will document both server ...

We have SQL Server 6.5 (soon to be 2000) and I was wondering if there is a query analyzer for Linux that would be able to execute queries on it.

How to Create a Table From Query Results in Microsoft SQL. If your business uses relational databases to store data, you may have used a SQL SELECT clause to create new tables from query results.

Does anyone know how Query Analyzer calculates the cost for the various values it gives, particuarly stuff like "Estimated I/O Cost" when you are looking at an Estimated Execution Plan?