check out

http://support.microsoft.com/kb/839279

You can shrink the database (reclaim unused space) with

DBCC SHRINKDATABASE

DBCC SHRINKFILE

See the books online for more information.

Have you tried increasing/decreasing max worker threads?

Do you have the truncate (remove unused space) on in your maintenance plan?

Sure you do the same type of backup (full, differential,...)?

Have you watched your performance counters?

Perhaps the server is too busy with I/O or something else.

Perhaps a difference on servicepack level of the clienttools.

Do they match the sql server servicepack level?

You will have a performance drop since it needs to communicate with another server.

How large the drop will be depends on the amount of data & network latency.

Your commandtimeout is adjusted to 10 minutes?

Is there any rollbacks of  transactions?

You can post your query in the T-SQL forum if you need to speed it up.

Hello again.

Normally when there is a time-out you get an error.

The stored procedures does return the results in the query analyzer?

SELECT *

FROM Table1

 INNER JOIN Table2

 ON Table1.Date = Table2.Date

AND Table1.Date >= convert(datetime,'20060324') /*always pass universal date, with function on the right allows indexes to be used*/

AND Table1.date < dateadd(d,1,convert(datetime,'20060324'))

Hello.

*Applying a function on the restrictive column is really nasty for your performance as you force out a full table scan instead of an index scan.

This also leads to additional...

The table definitions are the same? (char vs varchar)

*Closing the connections would be a great start. (releases remaining locks etc)

*Sql server's goal is to occupy memory till 4-10mb free memory is left over. (in dynamic memory allocation mode)

Motto: not...

1)Always specify the datalength when converting, otherwise you risk truncation

->CONVERT(VARCHAR(20),CREATED_DATE,101)

2)What datatypes are @START_DATE and CREATED_DATE?

Have a look at http://support.microsoft.com/kb/839279

it is the "full" version of the problem description.