Thanks Grant,

I'm going to do that right now and see how I get on.

Thanks for this recommendation.

Regards

Farren

Thanks ktflash,

I'll feed this back to the developers and see if they can do anything to speed this up.

It's only more tricky as they are a third-party.

Regards

Farren

Thanks Andrey,

I'll take a look at the 'forced parameterization' and get that implemented on a test environment.

Point taken on the cars analogy. I can see how focussing on total records...

Hi,

I have attached the sql being called by the report. It's just called from a simple front-end url with only a handful of paramemters to choose from, and in this...

Quite 🙂 I wanted to do my best to solve the issue myself, but seeing as this SQL stuff is now just an addition to my other jobs, I figure...

Hi all

Thanks for your help with this.

Seeing as it's my first day for real and there are clearly a lot of problems with this I have put it back to...

No, definitely running on the correct Db.

It's does actually have the correct USE statement at the top but I forgot to paste it.

If my user has sysadmin privileges, do I...

Ah, good point. Ok, might be overkill, but the script looks as follows 🙂

/****** Object: ForeignKey [FK_tblCurrentUsers_tblMemberMain] Script Date: 03/19/2009 11:30:02 ******/

ALTER TABLE [dbo].[tblCurrentUsers] DROP CONSTRAINT...