I don't think its so much the number of rows in the tables as the number of tables I am joining.  I am sure I can improve the performance but I...

Hi, I tried the version above but it just ran and ran and I had to kill it after a few minutes.

I also tried redesigning it myself with no subqueries ...

derived table?  No idea what that means and it sounds more complicated than simply passing as a parameter!

Sub-queries - yes I know they don't help - I inherited this database,...

Well well well well!!!!

Passing @CampaignID as a parameter does the trick - it consistently takes 15 seconds now.

I'm really surprised by this.  I'm sure most developers are unaware of this...

@CampaignID is a smallint, which is consistent with how it is defined in the tables as well.

@UploadControlID is a passed in parameter, and @CampaignID is retreived within the SP based on @UploadControlID, so yes it's local.

But if I retrieved it before I call the SP and...

Interesting idea.  I have run DBCC FREEPROCCACHE and I am running the SP again... although it takes about 7 minutes to run so I'll report back after this time.  Hopefully...

I could create dynamic SQL to get round this which I think would fix it but that's a messy way of doing things and future maintenance would be like cracking the Da...

Definitely agree that different people within companies can have different perspectives on how good the company is.  Depends on what your boss is like and what your colleagues are like...

I would tend to agree. There are many small companies that wuld never make a list like this but are far better places to work in than large blue chips...

But in Spain you get a siesta which I could do with every day!  Although I suspect that doesn't really happen in office environments...

I would say a degree is quite...

I don't fancy doing a survey here but I am interested in what is regarded as a good deal in the US compared to the UK, or even the rest...

Is that the '100 Best IT Companies in the US'  or are the 100 best IT companies to work for all in the US?

Or do people in the US forget...