Thnaks guys, I have setup a test system where I was able to replicate the problem.

Transaction 1: Random Deleted

Transaction 2: Random Updates

Transaction 3: Random Updates/Selects

In the end, it...

thanks guys

Thanks very much for this information.

Thanks for the reply, so what you saying is that sp_helptext needs to be used and the line number traced.

Is it possible to setup a trace that only tracks those...

Thanks for the posts guys, from the sql log details below, I know the 2 stored procedures that are suspect, I just need to know what objects/operations they are working...

just forgot to say, on the index code, client_id is the first column, the code I placed on my last post was copied from a previous post and not the...

you might notice some variations in the column, but its still thesame thing.

Hi Guys,

I have tried the index with the INCLUDE statement, and although it doesnt seem to make much diffrence to be honest, in fact when used in the view, it...

Hi Guys,

I forgot to say that the tables have a check constraint.

ALTER TABLE [dbo].[Marketing_200901] WITH CHECK ADD CONSTRAINT [CHK_Marketing_200901] CHECK (([ServiceDate]>='2009-01-01 00:00:00.000' AND [ServiceDate]<='2009-01-31 23:59:59.000'))

GO

ALTER TABLE [dbo].[Marketing_200901]...

cheers for the reply, I have already done this before and it didnt seem to make much difference.

Basically, on looking at the query plan, what I need to do is...

Thanks for the reply guys, but to my suprise, trying to start SQL agent from services wouldnt work, but after logging onto SQL Management Studio I was able to start...

sp_configure

did you enable AWE here ?

Hi,

Have you looked into enabling AWE, I think this is the only way to address more memory, might be worth telling us what your total/target server memory is from perfmon.

Thanks all, this has been very useful.

Thanks for the reply, the collation on the tables is as follows:

Latin1_General_CI_AS

The problem is that, I am currently not on site at the moment and do not currently have...