you keep dropping col1 from your index for some reason..

another workaround for ineffective TOP will be rewriting queries as

Select ... from Server1.MyDatabase.LinkedServer.MyTable (instead of dbo schema),...

you probably need to rewrite the query and remove "TOP" clause - it executed on local server, not remote, so you pulling entire resultset between boxes.

simplest way

Declare @MetricDate smalldatetime

Select...

many wanted to remove header from SQL Agent job step output file - all failed.

you can convert job step to CmdExec and call osql -o, or to Integration Services Package,...

kindly read up about linked server, LIKE '%,%' and EXISTS operators (previously mentioned MERGE will also work)

you need to parse search string and compose FTS query sting, no easy "replacements" here.

C# example[/url]

check SQLAgent account permissions