Hi K. Matsumura

Thanks for taking the time to play with the queries, that's the best way to know what will work best in your environment.

These tests were conducted using SQL Server 2000 SP4.  I re-ran the tests this morning on a couple different servers to verify that the results are still similar to what they were when I wrote the article, and they are.  I also ran them on SQL Server 2005 SP2 with the same trend in query times.

However, when I ran them on my workstation, today (I had only run them on servers before), the numbers worked out the way you have recorded: faster for the NOT IN() (10 seconds for 100 iterations) than for the NOT EXISTS (12.6 seconds).  Something to do with the newer hardware in the workstation, perhaps (single processor, dual-core workstation vs. dual processor, single-core, server)?

KenJ