TheSQLGuru (4/22/2011)

P.S. I specifically recommend that you do not REORGANIZE your indexes. Reorganization (defragmentation) takes about 8 times longer than rebuilding, if pages in the table are exclusively locked, the...

Lots of good advice here. The one thing I learned back when I used linked servers is that you should do as much work on the linked server as...

A checkpoint should not cause connectivity issues. A checkpoint is just mark in the transaction log to signify what transactions can be overwritten because they have completed.

The value in singleton_lookup_count can help you determine the usefulness of the index. This basically says how many times a query is returning a single row from the index....

Once again you have me guessing as to the columns you are presenting especially in your outlier.

You keep on saying that your outliers are incorrect based on the ActivityDate, but...

Sound like you want to PIVOT. You can lookup the PIVOT function in BOL or you can look at the 2 articles linked in my signature line about CrossTabs...

Wow, really SQL 7 still?

SQL Server will take all available memory unless you have set the MAX memory setting, which you should set. I don't remember how to do...

You can use sp_testlinkedserver to test connectivity for a linked server. Something like the following would allow you to present an error message:

BEGIN TRY

EXEC master.sys.sp_testlinkedserver @servername = N'test';

END...

I'll second Koen's suggestion. I was going to suggest exactly what is in the other thread.

Edit: fixed spelling of name. Check out Phil's post to see how I...

We need more details.

What do you mean by stuck?

How is the job scheduled?

What is the job supposed to do?

Is there an error in the job history?

I want you to include all the data involved in your output so you can see what you are getting. You are not returning the TimeStamp column at all...

Thanks. A couple of things:

1. You keep using different data in the presentation so I have nothing to compare it to. If you could setup a consistent...

Have you run them both in the same batch to see the cost relative to the batch?

When I run a similar query they have the same "cost". I'd also...

You can use Database Mail with SQL Server Agent 64-bit beginning with SP1.

From this KB Article:

Note In SQL Server 2005 Service Pack 1 (SP1), you can use SQL Server Agent...

There are a lot of things that could be different.

Are the servers setup and provisioned identically?

What else is going on the servers?

Are index and statistics maintenance being performed on both...