Re: SQL Server

2 Questions

1. Where is the processing done in a pass through query?

2. One of the SQL Server programmers is pushing stored procedures, I guess
because the processing is done on the server and you're not relying on ODBC
to carry large amounts of data. Do you think a stored procedure for a
complex query is likely to have a significant performance boost vs a
traditional ODBC connection, linked tables and query?

"Duane Hookom" <duanehookom@xxxxxxxxxxxxxxxxxx> wrote in message
news:3EB6BC75-9617-47E2-9E89-C2D6EF97D4CE@xxxxxxxxxxxxxxxx
If you don't need to link to Access tables, I would consider using only
pass-through queries. If you need to change the criteria of your
pass-through
query, you can use a couple lines of DAO code to change the SQL property
of
the p-t.
--
Duane Hookom
Microsoft Access MVP


"JimP" wrote:

I'm currently using MS-Access to write reports using a SQL Server db as
the
data source in a client/server arrangement.

The database is sufficiently large (2gb) that data retrieval speed is an
issue.

The current setup is linked tables to the SQL Server db via ODBC, and
then
the usual queries.

1. Can views and/or stored procedures on the SQL Server side along with
paramaterized queries provide a significant performance boost?

2. I've read that views and stored procedures can be created w/i Access.
Is
this the same as creating them in SQL Server?

3. Are there other things I should try?





.

Relevant Pages

  • Extreme performance issues (SQL Server 2000/ADO.NET/C#)
    ... This process runs very quickly if run through Query ... same exact stored procedures and views, run in the same exact order, through ... system that runs SQL Server (a 4-cpu Xeons system with 2gigs of physical ... When I execute these steps manually through query analyser,, ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Index Seek (or) Index Scan in Execution Plan
    ... your queries do run better when you use them. ... Run your query with and without the hint, ... SQL Server MVP ... >>>> It is preferable to not use index hints, ...
    (microsoft.public.sqlserver.server)
  • Re: Index Seek (or) Index Scan in Execution Plan
    ... your queries do run better when you use them. ... Run your query with and without the hint, ... SQL Server MVP ... >>>> It is preferable to not use index hints, ...
    (microsoft.public.sqlserver.programming)
  • Re: Ongoing purging of active records causes deadlocks
    ... For a query like: ... plan for some of our queries and it looks like it sorts first, ... What is a possible alternative, though, is that the purge first performs: ... Books Online for SQL Server 2005 athttp://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books ... ...
    (comp.databases.ms-sqlserver)
  • Re: Access migration to SQL Server
    ... caveat in the first sentence, i.e. remove access all together and you don't ... > about having to convert all your queries to views and stored procedures. ... > using a named query parameter to look up a value from a form control and ...
    (microsoft.public.sqlserver.server)