The Problem with Where Not Exists

Do you know what the problem is?

I use Where Not Exists all the time, typically when I’m incremental loading. (a detailed video of how to do that can be found here)

Problem is, it doesn’t work as (at least I’d) imagine it would. In my mind Where Not Exists is the opposite of Where Exists although it isn’t!! That’s really important to know to stop you loosing any data.

In this video I will show you in detail how it works:

Note: I’ve recorded the videos in highest resolution possible. So please view them in 1080 or 720P (HD) for best quality. Cheers!

https://www.youtube.com/watch?v=c0Q-un2P4o0

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s