We use Quest Spotlight and Performance Analysis in our shop. I will have to say that even though we have Spotlight, it's not the end all monitoring tool that...

The senior DBA that I work with gave me that idea. So I cheated a bit... 😀

In case I completely misunderstood your question, here is a link to BOL that discusses the HOLDLOCK table hint.

ms-help://MS.SQLCC.v10/MS.SQLSVR.v10.en/s10de_6tsql/html/8bf1316f-c0ef-49d0-90a7-3946bc8e7a89.htm

See if this is what you're looking for.

SQL Server by default should be in pessimistic mode, which should give you the behavior you're looking for without table hints.

Thanks Grant!

We were fortunate that our Senior DBA was monitoring this server during the time frame of that exception. He was not seeing any CPU pressure during this time...

Sorry guys, I just noticed that my topic heading has "Count" instead of "Could", which is confusing.

My apologies...

Locking the SYSOBJECTS table down for an extended period of time is about as worse performance as you can get.

If you do a SELECT * INTO DestinationTable FROM...

Hi,

This is a link to a great article on SSC that should show you exactly what you need.

http://www.sqlservercentral.com/articles/T-SQL/70807/

I would suggest the following if you are working with a large data set.

Step 1:

SELECT col_name_1, col_name_2, ....

INTO My_New_Table

FROM Old_Table

WHERE 1 = 0

Then

Step 2:

INSERT INTO My_New_Table

SELECT...

The next question is has this query run for you in the past? Not going to make a real difference if it has, but will help you identify where...

Todd,

Is it possible for you to post the estimated execution plan for this particular query?

Well you have already started with the first thing that needs to be addressed when improving performance in a database. In many cases, regardless of memory or the disk...

I would have to aggree, the metadata would be part of the SSIS package. I'm also assuming that you're talking about SQL Server in this case. You have...

A possible useful query to further investigate the query plan use counts, if this is suspect.

SELECT usecounts,

cacheobjtype,

...

Without knowing your topology, I would now be curious as to what the difference is in the APEXSql and RS servers from your SSMS. Is your desktop local to...