Modern SQL server will handle everything above, technically exists works faster then anything else, so I voted for it.