Are there any jobs running regularly?

Is the DB set to autoclose?

Is the DB set to Autoshrink?

At the times things go slow, do you see any unusual blocks or waits in...

Ok, maybe this one...

SELECT depAir.Name AS departureAirportName,

dest.Name AS destination,

TotalFlights,

...

The two Stansteds are because they have different destinations. You want only 1 row per departure airport, regardless of where the flight is going?

I think the 2 rows for Gatwick...

How does this look?

SELECT depAir.Name AS departureAirportName,

dest.Name AS destination,

TotalFlights,

Offers.ARR_AIRPORT,

Offers.DEP_AIRPORT,

LowestPrice,

LowestPrice/NO_ADULTS AS Price,

Offers.DEP_DATE,

Offers.RtnDEP_DATE,

Offers.NO_ADULTS,

DATEDIFF(d, Offers.DEP_DATE, Offers.RtnDEP_DATE) AS duration

FROM cached_offers_flights Offers INNER JOIN

(SELECT DEP_AIRPORT, ARR_AIRPORT, COUNT(*) AS TotalFlights,

MIN(CAST(STANDARD_PRICE...

Once a week, reorganise an index if logical fragmentation < 30%, rebuild if fragmentation > 30%

Don't do both to the same index. It's redundant

GRANT ALTER ANY USER ON Database1 TO User1

Could you possibly post it as a create table please? I want to have a test table to try the query out on, and it's going to take too long...

That depends on why the database is suspect.

Please take a look at the SQL error log. See if you can find anyy message indicating why the DB has been marked...

magarity kerns (5/9/2008)

---

All I can suggest is that you write up an SLA that pretty much demands dedicated LUN performance without specifying it exactly and then filling their trouble ticket...

Checkpoint is a processes within SQL that writes all dirty data pages to disk. It's an automatic process.

Varchar(25) at minimum, or you risk losing part or all of the time.

Duplicate post:

http://www.sqlservercentral.com/Forums/Topic498211-146-1.aspx

Please don't cross post. It just wastes people's time answering questions that hav already been answered elsewhere.

It might be. Hard to say for sure. Give it a try and see.

What indexes do you have on those tables? How many rows does the query return?

Can you post...

Don't ever let an application use sa to connect. There's no way to prevent someone who knows the sa password from doing anything to the server.

Set up an user name...

Please don't cross post. It just waste people's time and fragments replies. Many people here read all the forums

No replies to this thread plese. Direct replies to the following thread

http://www.sqlservercentral.com/Forums/Topic498549-8-1.aspxthanks.