I agree. Not exists is usually a better option.

However depending on your version (even service pack or hotfix revision) of SQL, an exists still might scan all of the...

The problem is that there is no good way for a linked server to know how to optimize queries that refer to remote tables. So what always seems to...

Couldn't you solve the design problem by creating a new table (or series of tables) that contain all of the customer data in them with a customer ID s to...