Posted by MC on 01/25/06 10:41

Do you mean that actually specifing servername slows down the query? Could
you explain why?

MC

"Tom Moreau" <tom@dont.spam.me.cips.ca> wrote in message
news:dRsBf.4433$ft2.115520@news20.bellglobal.com...
> There's often a performance difference.
>
> --
> Tom
>
> ----------------------------------------------------
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Columnist, SQL Server Professional
> Toronto, ON Canada
> www.pinpub.com
>
> "MC" <marko_culo#@#yahoo#.#com#> wrote in message
> news:dr5eu2$s5q$1@magcargo.vodatel.hr...
> Agreed, but why not provide a more complete info since theres a little
> difference? He may need to pull data from two servers tomorrow...
>
>
> MC
>
>
> "Tom Moreau" <tom@dont.spam.me.cips.ca> wrote in message
> news:LBqBf.4368$ft2.109590@news20.bellglobal.com...
>> The OP said the two DB's were on the same server. Therefore, 3-part
>> naming
>> is sufficient.
>>
>> --
>> Tom
>>
>> ----------------------------------------------------
>> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
>> SQL Server MVP
>> Columnist, SQL Server Professional
>> Toronto, ON Canada
>> www.pinpub.com
>>
>> "MC" <marko_culo#@#yahoo#.#com#> wrote in message
>> news:dr5cc8$bue$1@magcargo.vodatel.hr...
>> Try 'four part names' :).
>> server.database.owner.table
>>
>>
>> MC
>>
>>
>> "Captain Nemo" <nemo@nospam.com> wrote in message
>> news:6oqBf.8267$wl.3901@text.news.blueyonder.co.uk...
>>> Hi
>>>
>>> I'm working on an ASP project where the clients want to be able to
>>> effectively perform SELECT queries joining tables from two different
>>> databases (located on the same SQL-Server).
>>>
>>> Does this involve creating virtual tables that link to another database,
>>> or
>>> am I completely on the wrong track?
>>>
>>> Any hints as to where I might find more information (buzz-words, etc.)
>>> would
>>> be most appreciated.
>>>
>>> Thanks
>>>
>>>
>>
>>
>>
>
>
>
>

[Back to original message]