Ho many rows are we talking about? You could try inserting these rows into a table variable using an order-by and run the aggregate against the table variable.That should run...

An index can't be used for this: where name like '%Name1%'

anytime you are searching for a pattern somewhere in the middle of the column the index seek cannot...

You will not have issues that prevent you from taking advantage of the performance enhancements of SQL Server or the new 64bit hardware & more memory.

In fact most of the...

Well stated Sir.

"Do not spoil what you have by desiring what you have not;

Remember that what you now have was once among things you only hoped for."

~Epicurus

A 64bit platform can make a marginal design run well because it can put everything back in main memory again which makes everything run faster again (for a while anyway)....

I believe what may be causing that is that when a database is restored it can end up with a new owner... if the login that restored it is different...

The description of your architecture does not sound optimal for what you are doing. At the very least you should ditch the COM crap, and retrofit using using...

tell me more about these com objects you are using.

Well, the query is aggregating rows based upon these unique entities:

case when sugar=1 then 'sugar' else 'bread' end, sp1, cl1, da, d.m, m.cu, m.to

So I am thinking that maybe...

If it were me I would make my best guess as to the proper type and do a trial insert into a table. To keep things simple and low overhead...

Without being able to test I might suggest the following:

select

case when sugar=1 then 'sugar' else 'bread' end as type,

sp1,

cl1 as pr,

da,

d.m,

m.cu,

m.to,

sum(case when sugar=1 then 1 else cast(init as float(10,2)) end)...

Heh heh, well, I was about to overlook your comment about the cats and dogs and commend you on your quality of preparation personal responsibility, but then I noticed you...

It was meant as a joke.

An issue regarding the extensive use of software/firmware and intercommunication in new cars is not only that of security, but of survivability.

Systems subjected to EMP or high level of radiation...

You may not close any topics, especially of yourself. It will be used for evidence.