Slow server

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

From: Muhannad Hamwi (anonymous_at_discussions.microsoft.com)
Date: 07/20/04 

Date: Tue, 20 Jul 2004 05:25:54 -0700

Hello,
Within ADO Connection, a stored procedure that generates
report took 30 seconds on MSDE2000(SP2), while the same
stored procedure on the same computer on SQL Server 2000
(SP3) took 30 minutes.
Is there any problem in configuration ?
Advise me please.

Relevant Pages

  • Re: Need an elegant solution around SQL Server Limitations
    ... but I am using the stored procedure to ... possible way it can interpret the custom field data. ... > which to report on. ... > Mike Epprecht, Microsoft SQL Server MVP ...
    (microsoft.public.sqlserver.server)
  • VB.NET and design-time dataset generated control
    ... One of the modules has around 7 forms and each form will print one report. ... Stored Procedure as "GetCustDetails". ... In this .xsd file, one field is manullay added called "Select" ... Now I sent the binaries to the client. ...
    (microsoft.public.vsnet.general)
  • Re: Possible to turn off grouping programatically
    ... Sorry, Drew, I missed that part of your question. ... know nothing about SQL Server, ... >>>generated from a stored procedure and can generate 2 different recordsets. ... >>>The first report is a good deal of records, but the second ...
    (microsoft.public.access.reports)
  • SOLUTION: Reports in ADP based on stored procedures; child rowset error
    ... I have a report that is based on a stored ... Then I just set the report's RecordSource ... Then I had to add a second parameter to the stored procedure. ... RecordSource property from my ADP report into the immediate window, copy it, ...
    (microsoft.public.access.reports)
  • SOLUTION: Reports in ADP based on stored procedures; child rowset error
    ... I have a report that is based on a stored ... Then I just set the report's RecordSource ... Then I had to add a second parameter to the stored procedure. ... RecordSource property from my ADP report into the immediate window, copy it, ...
    (microsoft.public.access.adp.sqlserver)