Re: Performance - Run Long Queries

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Richard Ding (rding_at_acadian-asset.com)
Date: 08/12/04 

Date: Thu, 12 Aug 2004 14:35:39 -0400

Yes it does. That's why it is highly recommended that a stored procedure is
used because it is only running on the server and can take advantage of
cached plans.

"Laurel" <landj.griffith@attbi.com> wrote in message
news:4e0801c48098$347dcae0$a301280a@phx.gbl...
> A question about long running queries. We have an
> application that is running across a WAN. We are trapping
> long running queries. Does the timing of the query
> include serving the data set back to the requestor?
>
> L
>
>

Relevant Pages

  • Re: SQL/ADO (2.8) Timeout Error - Cant resolve
    ... > Server 2000 back end. ... > timeout limit. ... And I’ve used SQL Query Analyzer to run the ... I am running a stored procedure that will backup a SQL Server ...
    (microsoft.public.sqlserver.clients)
  • Re: How to test a custom conflict resolver procedure
    ... once I set my stored procedure as a custom resolver? ... Here is an example of a custom resolver I wrote which might help you ... --creating the stored procedure conflict resolver ... Looking for a SQL Server replication book? ...
    (microsoft.public.sqlserver.replication)
  • Re: quality of service
    ... company that hosts my company's web site and connected SQL Server database. ... The same stored procedure is called from a number of different web pages ... The company that hosts my web site and connected SQL ... this clustering is indicative of slowed or failed SQL Server responses due ...
    (microsoft.public.sqlserver.server)
  • Re: Error: Executing Stored Procedures-- Cannot Pass TimeStamp Values From sqlCommand Object Parame
    ... The @RowV Values when it reaches the stored procedure on SQL server always gets reset to 0x00 No matter what value I set it to. ... I am using timestamps to determine if the row has been updated on the server before I apply the new updates. ... @ProviderID smallint, ... @RowOut timestamp OUTPUT ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Problem using SP as record source with Access2002 & SQL Server 7
    ... I've installed a brand new copy of SQL Server 2000 with the original ... I've created the folowing stored procedure for the resync ... Resync Command: ALL_CUSTOMERS_RESYNC? ... I need to upgrade to a newer version of Microsoft SQL ...
    (microsoft.public.access.adp.sqlserver)