Thanks for your response, i think i have managed to peice together what is happening.

Our Veeam replication job is not set to truncate the logs; it simply performs a full...

I managed to resolve this issue.

The application automaically capitalised the password prior to submitting it to the SQL Server for authentication; you just couldn't see this because the password was...

I feared this may be the case, thanks for taking the time to respond.

Thanks for the reply, a problem shared is a problem halved as they say.

My database files are on a seperate volume, it is the install directory which is installed on...

Thanks very much for the reply. All disks are working fine, we have sent performance information exported from the array to the manufacturers support team and they are convinced that...

The issue was a result of parameter sniffing, thanks for all your suggestions.

Thanks very much for the prompt replies.

Thanks for the advice, a number of different approaches have been buzzing through my head and i wanted to see how others would proceed if faced with the same problem...

At this stage we have no limitations; i would envisage data could be out of sync until the end of the working day at which point the various applications databases...

Thanks very much; i will read through the links that you have provided.

Okay thanks for the advice; i'll read through the reccommended artcile.

I agree with your solution but the answer (according to the practice test) states that the first thing you should do is alter the partition function of the BillHistory table...

My apologies, i meant to reply to this sooner to give closure on this thread.

As has been suggested, creating a static copy of the data being 'cursored' has stopped the...

I'm having a similar problem; except that i am using standard edition.

For some reason i don't seem to have the option to install ssrs. Does anyone have any suggestions as...

Thanks very much for you help, this is now set up and working.

Just to flesh out your explanation a little; here are the steps i followed within SSMS.

1. Create a...