No, COPY_ONLY only breaks the differential "chain".

Managers and users shouldn't need to worry about warmth and fuzziness - that's why they pay you to administer their databases. Although if...

You could deny the application account whatever permission it needs to run backups, assuming that doesn't break anything else.

John

Use ROW_NUMBER() over that first column, and just select the one where the row number is 1.

John

What was that - sample data, expected results, or actual results?

Anway, if I understand correctly, your question is why the SELECT statement returns more than one row? The answer...

Chris

Please will you post the whole query, along with some sample data? What results do you get, and what results are you expecting?

Thanks

John

I can't see anything there that would obviously run differently under different settings. What I advise you to do is to capture each event with a trace, and capture...

There are some things you can check. Do any batch processes, backups or database maintenance run during the slow period? You can query your plan cache for the...

Be careful when you do this, because if someone has already compensated for the collation difference by putting COLLATE Latin1_General_CI_AS clauses throughout the code, then things may start breaking.

John

Andre 425568 (8/12/2014)

---

I will so what the settings are in SSMS and SSIS, but I do not think that is the issue, the normal queries, that also run from a...

Yes, that'll work if you want to run it interactively. If you want to automate it, you'll need to centralise using SSIS or similar.

John

For SSMS, go to Tools -> Options -> Query Execution -> SQL Server -> Advanced. For SSIS, it depends on the properties of the network library you're using to connect...

That's what I thought you meant, and it's why I suggested you compare your options on SSMS to those it uses when run through SSIS.

John

You said you were using SSMS.

John

For SSMS, go to Tools -> Options -> Query Execution -> SQL Server -> Advanced. For SSIS, it depends on the properties of the network library you're using to...

Andre

First, do you really need those cursors? If you can find a way to do your update with a set-based query, it's likely to run much faster. Second,...