Re: Slower Query from Morning to Afternoon

From: Kalen Delaney (replies_at_public_newsgroups.com)
Date: 07/28/04 

Date: Wed, 28 Jul 2004 14:33:21 -0700

As far as not knowing the appropriate place, it is fine to post to multiple
newsgroups, if you do it in the same message, and just list all the groups
on the same line. That way, any response will be seen in all the groups you
posted to, anyone thinking of answering will know what has already been
discussed, and there will only be one thread for you to keep track of. It
works better for everyone that way. 

--
HTH
----------------
Kalen Delaney
SQL Server MVP
www.SolidQualityLearning.com
"hdsjunk" <anonymous@discussions.microsoft.com> wrote in message
news:610301c474db$3e5ae2a0$a501280a@phx.gbl...
> sorry...I didn't know the appropriate place to ask
>
> You could have helped instead of being so negative about 2
> of the same posts existing.
>
> >-----Original Message-----
> >You have asked this question on several different
> newsgroups and you now
> >have several threads of responses to follow.
> >Please do not multi-post as it makes it hard for everyone
> to keep track of
> >what has already been answered.
> >
> >--
> >HTH
> >----------------
> >Kalen Delaney
> >SQL Server MVP
> >www.SolidQualityLearning.com
> >
> >
> >"hdsjunk" <anonymous@discussions.microsoft.com> wrote in
> message
> >news:5cee01c474be$98582be0$a301280a@phx.gbl...
> >> I sure hope this is a common question with a common
> >> answer...
> >>
> >> I have a SQL database that the users interact with
> using a
> >> VB application.  They are able to build and run their
> own
> >> queries all day.  We have noticed that a query they may
> >> run in the morning returns in seconds, but the same
> query
> >> against the same data ran in the afternoon hangs up or
> >> returns in minutes.
> >> Does anyone have any thoughts about this?
> >>
> >> They can also make updates, and the auto-update/create
> >> statistics is enabled on the server.  I'm not a hardware
> >> person, but according to the Network Administrator,
> there
> >> are no issues regarding traffic or hardware.
> >>
> >> I hope someone can help, I'm desperate...
> >>
> >> Thank you!
> >
> >
> >.
> >

Relevant Pages

  • Re: Slower Query from Morning to Afternoon
    ... SQL Server MVP ... > I sure hope this is a common question with a common ... We have noticed that a query they may ... > are no issues regarding traffic or hardware. ...
    (microsoft.public.sqlserver.programming)
  • Re: Slower Query from Morning to Afternoon
    ... >SQL Server MVP ... >> I sure hope this is a common question with a common ... We have noticed that a query they may ... >> are no issues regarding traffic or hardware. ...
    (microsoft.public.sqlserver.programming)
  • Re: Slow Query from Morning to Afternoon
    ... SQL Server MVP ... > I sure hope this is a common question with a common ... We have noticed that a query they may ... > are no issues regarding traffic or hardware. ...
    (microsoft.public.sqlserver.server)
  • Re: Open Source Enhancement
    ... And he has posted in a wide variety of ... newsgroups, on a wide variety of topics, with the same mix of ... Perhaps high-level programming markup language? ... writing drivers for hardware from companies that release no hardware ...
    (comp.unix.bsd.openbsd.misc)
  • Re: where to get mySQL questions answered?
    ... In message, Randell D. ... Remember Google keeps a good index of the newsgroups and I ... >query works with one word, but not two - and it seems that your code might ... >be passing the syntax of the query wrongly (perhaps leaving your database ...
    (comp.lang.php)