Yeah, well thats the problem, rock - hard place...

It is unfortunately the answer that I expected.

As a matter of interest, is there any real difference between TOP or SET...

I am seeing the same thing, with regards to SQL only getting up to 1.7 gigs of memory, with about 790mbs remaining, but it will not use it.

Have Page...

good idea, and it is usually some that I insist on as well.

But no luck....

Thanks for all the advise.

I believe the function is correct. I have created a second function, which is exactly the same, except for the name and now the correct values are being returned correctly.

0 and 1 s only being returned.

I am going to create as 2nd function for now, as a temporary workaround, until this can be sorted out.

sounds good, will test.

Thanks for the responses.

CREATE FUNCTION dbo.fnc_GetManagerForOrgIdAndDate (@OrgId int, @BusinessRoleId int, @Date datetime)

RETURNS varchar(64)

AS

BEGIN

DECLARE @IndividualId int

DECLARE @ManagerName varchar(64)

DECLARE @BusinessRoles Table (BusRoleId int)

IF @BusinessRoleId = 45

BEGIN

 INSERT @BusinessRoles SELECT 57

 INSERT @BusinessRoles SELECT 58

 INSERT @BusinessRoles SELECT 59

END

ELSE

 INSERT @BusinessRoles SELECT...

Thank you for that, got some work ahead of me, but at least I now know what direction I need to run in.

Thanks for the help!

Ok, thanks for that Brian, I will have a look for that book.

Transaction logs are on a RAID1 drive already, with ALL data files on a RAID5 (including tempdb).

Basically...

The concern is this:

If a failure occurs to the motherboard or array controller while the controller is busy writing, there is going to be corruption of data. Personally I am...

Thanks for all the responses, most helpful

Any info on this, as I am having similar problems?

Thanks,

Graham

Well the array consists of 3 x 146.8GB harddisks.

Seeing spikes continuously, with values from 1 to 12...

So basically I need to keep it under 6?

Thanks for the response!

Another question that just came to me, could disk defragmentation cause IO problems, like this?

As we are in the process of buying DiskKeeper.

Thanks,

Graham