Re: Problem using Access or Query Designer to run queries in SQL S

On Tue, 17 May 2005 13:04:04 -0700, "BI_Specialist"
<BISpecialist@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:

>Whats the best client or most efficient way to query data in SQL server for
>an end-user, that is user-friendly (no coding required) and does not bog down
>the server?
>Is Microsoft planning such a tool or 3rd party tools my only safe bet?

The best way is to code as much as possible in stored procedures,
expecially if the result set is going to be read-only, and let the
users execute the stored procedures. If you want to provide the
illusion that users are querying against base tables, you can create
views that reflect a subset of the data and let the users select from
the views. Unfortunately there isn't anything out of the box that can
create efficient queries because so much of what constitutes
efficiency is the relational design of the tables
(overnormalized=bad), how aggregates are created (on server=good, on
client=bad), indexing, network speed, etc. -- all things that have
nothing to do with the tools you select for the client to use on the
FE. So the bottom line is that the developer has to do a lot of the
coding on the back end to make it (a) a seamless, code-free experience
for the user on the front end, and (b) an efficient application.

--Mary

.

Relevant Pages

  • Re: Data hiding
    ... My problem is that my client doesn't do all db-access ... without forcing the client to use stored procedures? ... > from the underlying tables, and created Views based on suser_sname as ... >> So SQL Server does not directly support VPD, ...
    (microsoft.public.sqlserver.server)
  • Stored Procedure security
    ... We are designing a license mechanism for our product based on SQL Server. ... The license mechanism and the SQL Server will be installed at the client ... Encrypting Stored procedures is a limited solution. ...
    (microsoft.public.sqlserver.security)
  • Re: ADO.Net and transaction locking
    ... using stored procedures than you do ... from the client where more round trips are involved. ... business code to the server, that's not what the CLR was designed for. ... Also, with the CLR now in SQL Server 2005, is there push to move business ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Access 2007->SQL Server2005 "connection was forcibly closed",G
    ... I think it will ameliorate the situation if you clean up the client as ... And to come back to my problem: I think with help of the SQL Server admins ... closed connections - but all of these errors are in the version which used ... Every new client opens again 30 connections if I open 30 tables ...
    (microsoft.public.sqlserver.connect)
  • Re: Best way to populate webpages from multiple tables
    ... tables within hash tables, custom classes etc. ... > Set a session expiring cookie at the client that stores the Customer ID. ... > send it to the client, instead store it in your session mgmt sql server - ...
    (microsoft.public.dotnet.framework.aspnet)
Loading