Finding records in one table not present in another table II
In previous topic here
http://weblogs.sqlteam.com/peterl/archive/2007/09/20/Finding-records-in-one-table-not-present-in-another-table.aspx
Michael Valentine Jones suggested an alternative route to get all records from one table not found in another.
Here are the results (including my suggestion with only MIN(t1) = 1 as MVJ2)
SQL 2000 CPU DURATION READS WRITES
Original 1781 1783 30667 0
Peso 1 0 0 29 0
Peso 2 0 0 31 0
Peso 3 0 0 16 0
MVJ 1 15 16 16 0
MVJ 2 0 0 16 0
SQL 2005 CPU DURATION READS WRITES
Original 19563 19763 98546 0
Peso 1 16 158 14114 0
Peso 2 16 128 28 0
Peso 3 16 119 28 0
MVJ 1 31 120 28 0
MVJ 2 15 115 28 0