Re: Slower Query from Morning to Afternoon
From: Kalen Delaney (replies_at_public_newsgroups.com)
Date: 07/28/04
- Next message: John Bell: "RE: Simple query with inner join"
- Previous message: John Bell: "RE: Performance : Database splitting."
- In reply to: hdsjunk: "Slower Query from Morning to Afternoon"
- Next in thread: hdsjunk: "Re: Slower Query from Morning to Afternoon"
- Reply: hdsjunk: "Re: Slower Query from Morning to Afternoon"
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 28 Jul 2004 12:05:17 -0700
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!
- Next message: John Bell: "RE: Simple query with inner join"
- Previous message: John Bell: "RE: Performance : Database splitting."
- In reply to: hdsjunk: "Slower Query from Morning to Afternoon"
- Next in thread: hdsjunk: "Re: Slower Query from Morning to Afternoon"
- Reply: hdsjunk: "Re: Slower Query from Morning to Afternoon"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
