Re: Slow Query from Morning to Afternoon
From: Kalen Delaney (replies_at_public_newsgroups.com)
Date: 07/28/04
- Next message: Raziq Shekha: "View dependencies in SQL Server"
- Previous message: CD: "Re: SQL Server 2000 Data Check and database backup."
- In reply to: hdsjunk: "Slow Query from Morning to Afternoon"
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 28 Jul 2004 11:56:30 -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:5f2f01c474c5$1977fdd0$a501280a@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: Raziq Shekha: "View dependencies in SQL Server"
- Previous message: CD: "Re: SQL Server 2000 Data Check and database backup."
- In reply to: hdsjunk: "Slow Query from Morning to Afternoon"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
