Added attachments to show the difference

If I delete the the agent job it will just re-create it in 5 minutes time. I have fixed he stuff now, but somewhere in the reportserver/reportservetempdb there is a...

The question I would ask is where are you displaying the output. Is it in Excel, reporting services? I gather you want to get sales per month or something similar...

Just an idea. Don't know if it would work but worth a shot.

Take your script and create it as a stored procedure in Master with SP_Name. You should be able...

http://support.microsoft.com/kb/934653.

Certain things do not work. I have certain things.

Thanks for the help guys. I will check out all the options.

As for the SSIS thing, from what I understand you can't execute an SSIS package frrom a SQL job...

I have the /3GB set, you are suggesting changing that to /6GB. By tomorrow afternoon my server will have 30gig RAM available. I am going to allocate 20gig to SQL....

See, it's not climbing thats the problem.

If I run perfmon. SQL is hovering around 13gig. Which is perfect. Analysis services has a maximum of 1.6gig, that wont climb, and doesn't....

See, I have plenty memory available. TotalServerMemory is set to 80. It is a %, but of what, it says physical memory, but is that available memory, why does it...

Yes, I am running 32 bit, but how do I actually assign more memory. Where is the option?

What is the SP_Configure equivelant for Analysis services. I can't find it...

Unfortunately due to project contraints I didn't get chance to try this. I changed the way SSIS was pulling the data to pull a small chunk every day as appossed...

Thanks, I will give that a try and see what happens.

My opinions.

1. Yeah, the second method would be better, but it depends what your query thereafter does. I try stay away from large queries wrapped in IF statements, rather create...

Would a whole bunch of unions not do, or inserting results into a temp table. I think you need to give a bit more information on this.

Thanks for the help guys, checking out the blogs now. I actually need to sit down and analise whats going on myself. How to avoid certain things etc. Hopefully be...