ok - ive tried smaller and longer date ranges and the smaller one definately chooses a more inefficient path (attached)

Key lookups appearing on the smaller date range plan, as well...

Hi there,

I work for the same company as the original poster (Neil) and wanted to make an addtional point on the problem we are having...

The original query is ineffecient depending...

HI guys,

ive attached the actual execution plan, as well as the estimated plan and statistics io log from a LIVE report run.

The customer_sales_work_list view has also had some predicates added...

Hi - see attached for exec plan.

Ive tried to cover all the basic stuff like the clustered index scans where the predicate is not using the clustered index, i have...

Hi,

how is the best was to post the execution plan here? i can get an xml sqlplan but it is huge

Thanks

Indexes have been added where needed but the main issue is the number of physical reads the report is having request.

[Code]

(1062 row(s) affected)

Table 'Worktable'. Scan count 0, logical reads 0,...

Can you post the syntax your using? also did the Bulk insert work before you patched to SP4?

See attached for SQLCMD usage..

SQLCMD

Have an input sql script - i.e. your backup database script. Put the sqlcmd command into a batch file and feed the batch file into scheduler

if you want a freely available seperate backup agent then try idera sqlsafe freeware

http://www.idera.com/Content/Show68.aspx?CartID=1011

Very useful compression agent. Usually compresses at around 20% of orginal db size depending on data held...

How many Gb is your C:?

Pagefile is a good call from Roy.

If the server is used just for SQL Server, then remove any unnecessary applications that may have been...

Personally dont see this being a problem.

We have a one instance transaction replication setup - to copy real time data from live into a reporting database - to split load

Yes - distributor and subscriber are sitting together - direct link - not a router/switch timeout.

The way I got round this problem at the weekend was by manually BCPing the...

Hi Thanks for the reply.

This is transactional replication from Oracle onto a sql server distributor server, and then onto another sql server subscriber.

Am i right in assuming that the QueryTimeout...

Hi,

i'm trying to find out why the subscription would be marked for reintialisation? the attempts to run the transaction were over a period of about 2 hours - no where...

can anyone confirm the above reply? i had a similar issue in that after about 65 attempts to retry the transaction, no more retries were attempted, and the distribution agent...