Re: faster joins

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: SKG (sunil_godiyal_at_yahoo.com)
Date: 06/24/04 

Date: Thu, 24 Jun 2004 16:23:04 -0500

Thanks!! Kevin. With in the same server will the query be treated as
distributed query.
"Kevin Spencer" <kspencer@takempis.com> wrote in message
news:%23CjNbniWEHA.3972@TK2MSFTNGP12.phx.gbl...
> As long as they are on the same SQL Server, the JOIN would be just as
fast.
> Distributed queries are expensive.
>
> Kevin
> "SKG" <sunil_godiyal@yahoo.com> wrote in message
> news:##W7sbiWEHA.204@TK2MSFTNGP10.phx.gbl...
> > I have two databases with in same sql server.
> > I want to know whether a join of two tables with in same database is
> faster
> > or than
> > join of tables across two databases
> >
> > Thanks!!!
> >
> >
>
>

Relevant Pages

  • Re: faster joins
    ... A Distributed query is a query which involves databases on different ... With in the same server will the query be treated as ... > "Kevin Spencer" wrote in message ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: faster joins
    ... "SKG" wrote in message ... Kevin. ... In fact you cannot run distributed query even with loopback linked server to ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: DNS Creation issue on child domain.
    ... "Jorge Silva" wrote: ... When I ping the server by name at the server, ... Kevin J ... Default Application Directory Partition for DNS. ...
    (microsoft.public.windows.server.active_directory)
  • Re: OE6 slow to open messages.
    ... uncheck the option to leave a copy on the server. ... "Kevin Lawton" wrote in message ... Then again, Temp Internet ... Click Tools | Internet Options. ...
    (microsoft.public.windows.inetexplorer.ie6_outlookexpress)
  • Remote Indexing / Distributed Query
    ... I'm trying to access an Indexing Service located on a remote machine using ... On the first server, the Indexing Server is up & running; ... the Indexing Service is stopped. ... distributed query facility is limited to the server where both SQLServer and Indexing ...
    (microsoft.public.sqlserver.fulltext)