Re: Query question

From: Gregg (anonymous_at_discussions.microsoft.com)
Date: 06/14/04 

Date: Mon, 14 Jun 2004 15:09:46 -0700

Nothing I try seems to help the runtime. I think I'm
going to shoot the server. Thanks for the help.
Gregg
>-----Original Message-----
>In the SQL Server Analyzer, check the step that uses the
highest percentage
>of processing time. The problem will be around there.
It likely to be the
>hash Table (tunable???).
>
>OTOH, it is much better to use Pass-Through Query since
in PTQ, the
>processing is done by the SQL Server and only data from
the selected rows is
>send through the network to the PC.
>
>--
>HTH
>Van T. Dinh
>MVP (Access)
>
>
>"Gregg" <anonymous@discussions.microsoft.com> wrote in
message
>news:1b42201c44fcc$bd397ac0$a501280a@phx.gbl...
>> I did use SQL Server's Query Analyzer, that's Analyzer
>> with a "z", and got the no tunable tables. On the
comment
>> of John's, I replied to it and said, it make s no
>> difference if the table is joined or not, the runtime
is
>> the same. Thanks for the help so far. Is there anything
>> else you can suggest?
>>
>
>
>.
>

Relevant Pages

  • Immer noch Probleme mit dem Debugger
    ... Client (Query Analyzer) und SQL Server nicht auf der gleichen Maschine ... Gezielt gesetzte Haltepunkte waren dem Debugger ...
    (microsoft.public.de.sqlserver)
  • Re: Query question
    ... In the SQL Server Analyzer, check the step that uses the highest percentage ... of processing time. ... OTOH, it is much better to use Pass-Through Query since in PTQ, the ...
    (microsoft.public.access.queries)
  • Re: loading sql files from a master file Oracle equivalent
    ... In Query Analyzer, no. ... In the command-line tool OSQL, ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... Books Online for SQL Server 2005 at ...
    (comp.databases.ms-sqlserver)
  • SQL Server 2005 Express
    ... I've installed VS.NET 2005 Beta along with SQL Server 2005 Express Beta on ... I'm interested in connecting to SQL Server via query ... analyzer or a similar tool. ...
    (microsoft.public.sqlserver.server)
  • Re: ODBC Password
    ... Currently Using SQL Server 2000, ... just using the properties window of a pass-through query. ... exist in VBA code, nor do I know how to create it in VBA code. ... Will your suggestion work directly with the connection string ...
    (microsoft.public.access.modulesdaovba)
Loading