>>Always depends on the data at hand, but most uniform best times should be reached by piping the list of PK's into a temp table with index and inner joining to base select table, esp on longer PK-lists.
>
>Can't do this one but will do the benchmarks. This is a contained option and I doubt that visual notification of speed would be a factor.
There is a related thread on MSDN right now you may want to check
http://social.msdn.microsoft.com/Forums/en-US/transactsql/thread/78d64376-f4d8-471c-a642-db41f7c2f838
If it's not broken, fix it until it is.
My Blog