Yes and no. First of all, it depends...

Force a binary collation:

replace(col COLLATE Latin1_General_BIN2, char(0), '...

It seems to me that the confusion is really with:

Some designs are present in more than one table. You want to generate a list of all items in the FutureDesign...

Your post does not give much details. Do you mean that you first run the stored procedure and it gets stuck on an UPDATE statement. Then you kill the execution...

Your error was actually fairly trivial: you hade overlooked that the tag looks like this:

<Object Database="[bos_sommar]" Schema="[dbo]" Table="[currencies]" Index="[pk_cur]" IndexKind="Clustered" />

That is, the index name is quoted in brackets.

I changed...

Robert klimes (9/3/2013)

---

The last post for the exact same question asked on technet forums has an example of reading from 600MB with SSMS taking 45sec but reading from same table...

Very good point, Scott!

The problem is that we don't know how consume the data. TDS is not necessarily the limiting factor - TDS just passes the bytes. To get the data on the...

Yeah, that works too. And slicing the data in half is certainly a possibility. If you insert millions of rows, and you only have a single errors this may be...

If I get this right, you should get it working by adding the condition

AND Levels.Level = deleted.Level

The plot thickens...

Anyway, the stored procedure had quite a lot of INSERT statements, so why would only these two be slow? If it's a problem with mirroring, it could happen...

As you long as your stored procedure is not part of an outer transaction, it is doable:

BEGIN TRY

MERGE ...

END TRY

BEGIN CATCH

DECLARE cur CURSOR STATIC...

I don't have much to add to Andreas's response, but I note that your spec is somewhat vague. It would help to know more about this database, and why it...

Jeff Moden (9/2/2013)

---

If they're moving the app to another server, I'd hope they'd be moving the data, as well. Why not skip all the work with scripts and just...

Please forgive me. I like to help you with your performance problem, but I only have fragmentary information and it is difficult to piece things together.

It seems that you...