MsQuery

I've heard when using MSQuery on the client side, the where statement
gets processes at the client side, thus many records come across that
are not necessary. Is that true?
If so, would Query Analyzer be a better choice? We are trying to run
queries against our server (we are not in IT) and we have been getting
CBSIO errors.
ThanksCBSIO?
It does seem fine. I ran it from the OFFICE11 folder for Office 2003 and it
sent the where clause to the server. It might do it on the client if you
have disparate sources, but I would doubt it on the same server.
Query Analyzer would be better, but it does not have the joining tools that
MSQuery does. As long as you get the performance you desire, it should be
fine.
----
Louis Davidson - http://spaces.msn.com/members/drsql/
SQL Server MVP
"Arguments are to be avoided: they are always vulgar and often convincing."
(Oscar Wilde)
<bdaoust@.yahoo.com> wrote in message
news:1126273874.851824.292530@.g47g2000cwa.googlegroups.com...
> I've heard when using MSQuery on the client side, the where statement
> gets processes at the client side, thus many records come across that
> are not necessary. Is that true?
> If so, would Query Analyzer be a better choice? We are trying to run
> queries against our server (we are not in IT) and we have been getting
> CBSIO errors.
> Thanks
>|||Louis,
Thank you for the reply. When you say joining tools, what are you
referring to?
I guess I wouldnt miss them much since I dont even know what they are!
:)
Also, how can you confirm that the where clause was sent to the server?
Thank you.|||> Thank you for the reply. When you say joining tools, what are you
> referring to?
The query by example stuff that MSQuery has where you can pick the tables,
and it joins them for you, etc. If you don't need this and you are writing
SQL Statements in text, then query analyzer is the way to go anyhow.

> Also, how can you confirm that the where clause was sent to the server?
I used profiler and watched the statements being sent to the server.
----
Louis Davidson - http://spaces.msn.com/members/drsql/
SQL Server MVP
"Arguments are to be avoided: they are always vulgar and often convincing."
(Oscar Wilde)
"BerkshireGuy" <bdaoust@.yahoo.com> wrote in message
news:1126281216.691598.305900@.g47g2000cwa.googlegroups.com...
> Louis,
> Thank you for the reply. When you say joining tools, what are you
> referring to?
> I guess I wouldnt miss them much since I dont even know what they are!
> :)
> Also, how can you confirm that the where clause was sent to the server?
>
> Thank you.
>|||Aww I see, there is no design grid.
I am use to writing the SQL, so it will work for me. Hopefully IT is
willing to install it on my machine.
Thanks for the help.sql