sjsubscribe (3/10/2008)
Do you have difference lookup tables in the same database with different owners, or are they owned by dbo but in different databases/on different servers?
Yes.
Are you saying that both apply, or was I unclear in phrasing my question?
he best thing to do is to make sure you qualify all objects with the Schema...
No. It's not the best thing.
While basically everything falls into "It depends", it is still often, if not quite universally, advisable. 32ms of compile time may be insignificant, and a few ms on each run may be acceptable, but unless there is a specific need to choose a less efficient method, efficient is preferred.