Then it's definatly a parameter sniffing issue. Can you try another .net experiment please?

First revert back to the old stored proc, without the variables.

This time, instead of passing the...

Can't see the images, because they're on your machine. Could you paste the differeing lines of the exec plan, as well as the query that you called the .net with?

Thanks

It could be parameter sniffing. I wouldn't think so if you used the proc in SSMS, but is a possibility.

Can you post the proc, the code you used to call...

Have a look at the exec plan for both, see what the differences are.

In management studio, just run with the execution plan option on. for the application run one, you...

Is there enough space on the drive?

Is the drive (or folder) read only or encrypted?

Are the statistics up to date on both databases? Are the indexes on one more fragmented than on he other?

Pleasure

I saw your example. Why 3,1,2. why not 2,1,3?

As I said, if you want to have data in a specific order (whatever it may be) you have to specify an...

What do you mean by 'no order'?

If you want your data back in a specific order, you must specify an order by clause. Otherwise it comes back however the...

Or maybe what I've seen on a lot of other forums. The text bix to enter the new post is at the top of the page and all the other...

Try this way indstead. Aside from the divide by zero, it's better for index selection (if you have appropriate indexes)

Select *

from table t

where t.value_a > 10*t.value_b

AND t.value_c...

Or you can use sys.dm_exec_requests and pass the SQL handle to the sys.dm_exec_sql_text function and get the entire sql statement. (DBCC Inputbuffer only displays the first 255 characters)

select * from...

That's not ideal either because, at optimisation, the query optimiser can't evaluate the first half of the or. SQL doesn't have short circuit evaluation

The only way I've managed to deal...

Don't know about the global parameters, I don't think we use them. Our DTS packages are mainly complex data flows.

What we decided to do was to ensure that the people who...

Not sure if this is addressed to me or not, but I'll answer.

No, we're not using SSIS to exec the DTS packages. We imported the DTS packages as legacy objects...