Sorry for the 6 year delay in response but this happened to me today.  Here is the solution:

The problem is that something causes 1 table and 2 functions to be...

• This reply was modified 1 year, 4 months ago by  Sam Jumper.
• This reply was modified 1 year, 4 months ago by  Sam Jumper.

Timely post for me. Two days ago, I was troubleshooting a deadlock issue and found that deadlocks were centered around updates to a table which had a 3 column...

Thanks for the article, I've never used EXCEPT because I didn't realize it existed.

On the point of poor performance with large datasets, how can we expect anything else?...

Outstanding series! Thanks for writing it.

I second that! Thanks Gail. I can't wait to read Part 3.