David Conn (11/30/2011)

---

I had to run with the "Allow Data Loss" once. It was the only option left after it was determined that the Backups were rubbish. It was a...

1 or more of the "bad" plans have been dropped and rebuilt a different way.

This is a accidental fix. I'd be very surprised to NOT see the issue come...

How do you do the reindex?

Is it echo in here :Whistling:?

In the same train of toughts.

4 hour work week. Pick the audio version if you don't like to read cause it's awesome.

As a side note, SP4 will clear out many bugs, some of them might help with performance.

When in doubt, latest SP is a good default option. As usual, it...

Well actually in your case it would be to clean the select in the first place. Deduplication has many forms and purpuses so I can't give you a canned...

Insert into ...

SELECT... WHERE NOT EXISTS ()

jeff.coulson (11/30/2011)

---

Sounds like great advice, I'll work on that over time. Am I guessing correctly that we can build working functional processes with loops etc in the SQL stored...

SPs and version changes usually mean changes in the query optimiser. So means just that. Could be better, could be worse.

Usually people only complain about the worse part...

No we need the xml version, this is totally useless without the GUI 😉

@start

Start traceflag 1222. Then when it happens again, go to the sql error log and paste the deadlock graph over here.

In the meantime, you can use this instead of...

inayatkhan (11/29/2011)

---

like query is not much simple here I just create simple query to show the issue.

Is there any work around for this or I can create new temp...

I think I saw this before. IIRC this is more of a compile time issue.

Can you try ignoring the drops and doing #Mytemp1,2 & 3?