DBSophic, an innovative provider of performance management products for SQL Server based applications, announced that the company's Qure Analyzer solution has been ...

What exactly does 1 unit of cost represent in SQL Query Analyzer execution plans? [ie: Subtree Cost: 41.2134] Obviously it is some form of measurement since a very simple "select @@version" is like ...

SolarWinds has expanded its database performance management portfolio with the launch of SolarWinds Database Insights for SQL Server. Uniting the features and functionality of the SolarWinds Database ...

One of my favorite features in SQL Server Management Studio is the Template Explorer. It has been enhanced in 2008 to support new templates to help you use the new release effectively. Templates were ...

It’s interesting to see the response to this week’s announcement of MySQL’s new Query Analyzer (part of the subscription offering) and the forthcoming 5.1 release of the server. There’s been a lot of ...

I have been testing SQL Server 2008 RC0 (Release Candidate Zero) that was made available recently and I must admit I am beginning to like it. Even the new logo is growing on me. There are many new ...

SQL is neither the fastest nor the most elegant way to talk to databases, but it is the best way we have. Here’s why Today, Structured Query Language is the standard means of manipulating and querying ...

I need to create a three table inner join. It works correctly in SQL Analyzer, but fails when I run it inside ADO.NET.<BR>Here is a simplified query of what I am trying to do:<BR><BR>SELECT a.ID, b.ID ...