You could attempt this with a JOIN and a SELECT DISTINCT, but I think that probably a WHERE EXISTS would perform better, based on the assumption that there are maybe...

With the capabilities of today's commodity servers going up to 24 cores and 128GB memory on a single blade, you really only need to worry about scaleout if you are...