Stopping queries from timing out

#1

Any idea how I can stop a query from timing out?

I am running a simple but long query on a remote Progress table using DTS,
in order to pull data into a SQL Server Datamart, using a datapump
transformation task in my script.

However, to limit the amount loaded, I am trying to retrieve maximum and
minimum dates from the Progress table, which has over a million records.

The query is of this type:

Select Max(RecordDate), Min(RecordDate) from [Table]

But I keep getting timeout errors. I have increased the priority of the task
to high and put maximum values in the timeout fields on the remote
connection, but it still times out. Any ideas how to stop this happening?

#2

Does table [Table] have an index by [RecordDate]?, if not, try creating one.

AMB

"Ian" wrote:

Quote:

Any idea how I can stop a query from timing out?

I am running a simple but long query on a remote Progress table using DTS,
in order to pull data into a SQL Server Datamart, using a datapump
transformation task in my script.

However, to limit the amount loaded, I am trying to retrieve maximum and
minimum dates from the Progress table, which has over a million records.

The query is of this type:

Select Max(RecordDate), Min(RecordDate) from [Table]

But I keep getting timeout errors. I have increased the priority of the task
to high and put maximum values in the timeout fields on the remote
connection, but it still times out. Any ideas how to stop this happening?

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Stopping queries from timing out

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

Stopping queries from timing out - 04-01-2005 , 11:31 AM

RE: Stopping queries from timing out - 04-01-2005 , 01:37 PM