|
database
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
|
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 CBSIO?
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. -- Show quote---------------------------------------------------------------------------- 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) <bdao***@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 The query by example stuff that MSQuery has where you can pick the tables, > referring to? 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.-- Show quote---------------------------------------------------------------------------- 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" <bdao***@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.  |
|||||||||||||||||||||||
Other interesting topics