Denny's SQL Secrets Troubleshoot Slow-Running Queries In SQL Server Denny breaks down how to identify and fix speed issues in multiple versions of SQL Server. By Denny Cherry 12/11/2013 ...

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.

However, SQL Server 2016 also fully supports the rowset-to-JSON query scenario when you write a regular T-SQL query and then map results to JSON objects via the FOR JSON clause. For more information ...