you have to run the package using dtexec

here is a tiny bit of official documentation about why setting the max memory it all depends on what else you got running on the system

However, applications often use...

are the databases on the same server/hardware setup? second as Lutz said your slow queries temp table is like 500x larger than in your fast query. And are you sure...

doube post

ehm ok that might be to little for it... maybe you know in which folder the database files are in? with some luck there might be a similar named file...

use [my outlook crm db]

select file_id, name, physical_name, size*1/128 as sizeinmb from sys.database_files

something like this?

create table temp#( capacity float)

insert into temp#

values(13.7),

(74.3),

(189.7)

update temp#

set capacity = (cast((ROUND(capacity,0)/50)as int)+1)*50

select * from temp#

drop table temp#

and i am not looking to optimize your query but looking at the execution plan details will help to reveal and understand the different behaviour

indexes.. statistics... could be one of the reasons thats why i asked for execution plans

you have to add the size of the log file to 4gb

execution plans?

How to Post Performance Problems[/url]

ya different page but stillt on codeplex with a little searching... http://sqlserversamples.codeplex.com/#ssas

http://www.codeplex.com/MSFTDBProdSamples

not at all havent tested it in r2 but here is a connect ticket for it to track https://connect.microsoft.com/SQLServer/feedback/details/334180/data-collector-remove-data-collector-to-remove-associated-objects

nm