My first inclination would be to make this query a stored procedure so that all three tools have the best chance of using the same qeury plan. This should...

Since sysobjects contains "one row for each object that is created within a database, such as a constraint, default, log, rule, and stored procedure" (SQL Books Online). Then the...

The underlying table being locked is the "sysobjects" table, which feeds the INFORMATION_SCHEMA view, and others.

Before I answer without all of the correct facts, please see the link to a similar discussion below. It's very similar to your situation even though it's dealing with...

Ok, in our shop we do the following when working with large tables and transactions.

--This section strictly creates the table, and nothing else.

SELECT ColumnOne, ColumnTwo, ColumnThree... INTO TableName_Destination

FROM TableName_Source

WHERE 1...

TrailKing, is the second transaction running after the first transaction has completed?

Another note. I did not write this query, I'm just responsible for it when it runs like crap.

It feels like we have to rescue one of the servers every week from being brough to its knees weeping by queries like that, usually run by financial business users...

I agree....

Database design has so many variables to take into consideration. Contingency for tables and indexes, as well as how often tables are UPDATED versus read from. If...

You are correct, this is from a data wharehouse that does not adhere to OLAP standards.

Thanks for the replies and the sanity checks!

Here is the SELECT statement that was captured....

Seems pretty simple right?

==================================================================

SELECT SUM(case when disc_DiscountMC2 IS null then 1

...

Both funny and a good question...

The font is Consolas and the size is 10.5.

That's right, I did not have the correct reference for my namespace. Once I got that corrected it's been smooth sailing.

Thanks for the responses.

Problem soved, I have found my answer.