Thanks John Mitchell-245523 thats much better than what i had, its...

Hi, First of all apologies for not sharing all of the infoand my bad post.

I have attached the create...

Thats great thanks, it seems to work best using Cadavre's version

but now where would i stick my join in to display the company name, as soon as i try and...

Thanks, I’m not normally a fan of union was advised to stay away where possible as it’s not the best on method with performance. But that said the data being...

Ahhh of course, spot on thanks. Rookie mistake :Whistling:

Thanks that works .

Celko, we can’t all be great at statistics I’m sure even you had to start somewhere, thanks for the book refs though Ill look them up.

Hi I have already tried this

Yes it is set to 120832

I have set it to 118 GB of RAM but continually goes up to just under 128

Hi Yes sql service restarted even went for a server reboot.

I have also tried this using the interface and scripting it followed by restarts but nothing works

Hi

I too am having a similar problem, I have two environments both windows 2003 64bit enterprise, both SQL enterprise 64 bit both have 128GB of RAM both have sql...