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.

1) an oversight of waittypes in sqlserver

http://support.microsoft.com/?kbid=822101

2)The activity window in enterprise manager isn't autorefresh.

3) You could use the profiler if your query is composed of multiple steps, by watching...

1. The servicepacks are free and available at http://http://www.microsoft.com

It could be you have to pass a "genuine" validation first.

2. Yes, the latest servicepack includes all previous versions.

3.You can do...

Timetable

Timevalue datetime (time)

IsStart bit (value)

select Timetable.timevalue as starttime,min(table2.timevalue) as endtime

from Timetable

inner join Timetable table2

on table2.timevalue>Timetable.timevalue /*younger than*/

and table2.isstart=0

and Timetable.isstart=1

group by Timetable.timevalue

Renamed Time & Value because they are reserved words.

With some functions...

1)If you are only running scripts and all objects are owned bij dbo, I don't foresee problems regarding database ownership.

2)I haven't got the chance to work with sql 2005. In...