I didn't test the answer but I knew the following:

#2: UNION is not allowed to be used that way;

#3: That's not enough and will make things worse as every col1...

I see what you mean.

Every situation is unique and must be analyzed properly....

That's probably the best article I have read about transaction logs.

Can't believe I missed it before.

Thank you for sharing.

Best regards,

Interesting discussion.

Would the Full-Diff-Log backup method be recommended over the Full-Log method or it depends on the size of the database? I'm asking because I have seen both methods like...

I wonder that too since the result may be different in each SELECT of the view.

Maybe...

Ha. Got it right. And it was a tricky question. 😛

But a great one about a somewhat confusing subject (the ORDER BY, in that case, belongs only to the data...

Sorry...

This seems to be a parsing error and I don't think it has to do with SSMS as it's just a GUI (frontend) and it doesn't have control over query...

I see. 🙂

It'd be nice to see the actual code though to see if there's a problem with different database compatibility levels.

Best regards,

I have never seen such thing in T-SQL before.

Are you sure it's running properly on one of your PCs?

Best regards,

You could also use WHERE NOT EXISTS with a similar query like Sean's code.

Best regards,

ChrisM@Work(10/13/2011)

---

Even with the actual plan, this is completely unreliable. You need both CPU and io and the best way to do that is with actual timings or better still the...

You could try running a test example using the estimated execution plan button and the percentage taken by each method. I can tell you that the single UPDATE affecting several...

vk-kirov (10/10/2011)

---

Nice question

codebyo (10/10/2011)

---

That looks and executes right... but I can't understand why the result is not only the number 4.

After the EXCEPT, only the number 4 remains. So where...

That looks and executes right... but I can't understand why the result is not only the number 4.

After the EXCEPT, only the number 4 remains. So where does that 5...