In order for anyone to give you any meaningful help you need to provide much more details of your problem. What table(s) store this data that you need, if possible...

Sorry but I am not sure what you are asking here, what specific options are you referring to?

Mike

I would not rely on Window copy for anything that size across a potentially unreliable WAN connection. You need something with the capability of restarts after network errors. So something...

It all depends on what you mean by "not working". Do you get a specific error message, does it time out or what?

Best guess is the change you are making...

I expect the OR at the end of the query is likely to be your problem. Regardless of the date comparisons if the condition following the "or" evaluates to true...

You mention many things such as CPU, memory etc, but what disk configuration did you have before, and what do you have now?

Mike

Another vote for SVN and the TortoiseSVN shell extension. Allegedly GIT is better with a distributed repository but I have relied on SVN for years, and it has never let...

While backups frequently want to be totally automated, normally I find restores are done manually - especially for point-in-time issues requiring multiple log files.

Thus for backups I would normally favour...

Good catch thanks gents.

To be totally correct though it only returns 0 if ALL other characters are spaces.

Mike

Something like:

select

from ttt

where LEN(replace(REPORT_TEXT,'_','')) = 0

ie replace will replace them all with a zero-length string - if the result is zero length the column was entirely underscores.

This may...

As you say people will often say it "slows down updates etc" , but if suitably selective it will help the retrieval part, so overall will be often be beneficial.

If...

I would say identical for the "locate what to update" part. but then obviously a slight overhead incurred due to the need to update the index(es) if the column(s) that...

Certainly is and you were nearly there with what you wrote..

Select ... from T1

where col1 in (select col2 from T2)

or NOT IN as appropriate.

Some associated things to be aware of.

a)...

Thanks for the kerberos explanation - I had met the "double-hop" problem before with linked servers but not applied it to this problem. I will check up on data...

When you get a definitive answer to that one please let me know.

Mike