Where are you running the query, and where are you running the package?

John

I would recommend an SSIS package to run the same query against each server and write the results to a central location, where you can report on them.

John

Would [font="Courier New"]AND xxx.isactive = @parm_active[/font] not do it?

Are you saying that if you put the table names in instead of the subqueries, you get a different, less efficient execution...

What kind of scan - table scan, clustered index scan, or non clustered index scan? Please post the actual execution plan.

John

Rathi

It may not help performance, but it would simplify your query if you removed those subqueries and joined directly to the tables, and if you get rid of the CASE...

Please will you explain what your whole package is doing? I don't think the OLE DB Command is the right component to use. It belongs in a data...

Deliberate error. I'll let you work it out!

John

Run this while the delete is taking place:SELECT wait_duration_ms, wait_type

FROM sys.dm_os_waiting tasks

WHERE session_id = <SPID-of-connection-doing-the-delete>

What do you get?

John

You could remove the "- " and put an "01 " at the beginning. You'd then be able to cast it as date, subject to your local language settings,...

I don't think you need to use WITH RESULTS SETS. There is no result set. You could use WITH RESULT SETS NONE if you wanted, but I can't...

Paolo

We haven't seen Jeff's solution yet, but my guess is that's going to be the way to go if you don't want to modify the software. If you do...

RESTORE is a SQL command, not a command shell command. Use [font="Courier New"]EXEC (@sqlcmd)[/font] instead. And don't forget to escape those enclosed quotes by doubling them up.

John

As I suspected, then, the.mof extension is not recognised as that of an executable file. You'll need to find a program to open the file with.

John

WITH Rates AS (

SELECT

currency

, AVG(b.exch_rate) AS avg_rate

FROM uviexchrates b

WHERE date_from >'2015-01-01' AND date_from < '2015-12-31'...

Try these commands, one at a time in the same order:c:

cdcd "Program Files"

cd "Microsoft SQL Server"

cd 110

cd Shared

sqlmgmproviderxpsp2up.mof

John