Reply to: PM for SQL Server 2008

[suityou01]

Pot, kettle...

Reeeeeeaaaaaaalllly?

[d000hg]

Excellent first step. Now, as a mere suggestion, try reading it.

Pot, kettle...

[suityou01]

Yep - I've got it bookmarked.

Excellent first step. Now, as a mere suggestion, try reading it.

[mudskipper]

Execution plan basics

HTH

Yep - I've got it bookmarked.

[suityou01]

Execution plan basics

HTH

[DimPrawn]

Yep, if you've got the original plan...

[suityou01]

Dear SQL Server 2008

Please, please don't, without any warning or authorisation, ditch a query plan that has worked perfectly well and efficiently over a year and replace it with a plan that causes the query to run 120x slower.

Doing so is very annoying.

Many thanks
mudskipper

Get Bob to fix it.

[GB9]

I suppose that with not having any SQL Server skills I shouldn't have changed it myself. But can you fix it?

[mudskipper]

USE PLAN query hint.

Sorted.

Yep, if you've got the original plan...

[DimPrawn]

USE PLAN query hint.

Sorted.

[mudskipper]

When did you last update the statistics on the database(s)?
I suggest you do that first, and see whether it starts to use the old (correct) query plan again.

Did that. Didn't work. Users not happy, so had to resolve quickly. Adding ' OPTION (FORCE ORDER) ' seemed to do the trick, but guess this could happen to any query if the stats change.

[doodab]

I suggest you do that first, and see whether it starts to use the old (correct) query plan again or breaks loads of others.

Well, it might...

[eek]

When did you last update the statistics on the database(s)?

My guess is over a year ago.

[KentPhilip]

When did you last update the statistics on the database(s)?
I suggest you do that first, and see whether it starts to use the old (correct) query plan again.

[mudskipper]

A poor work(wo)man always blames ClientCo's tools.

FTFY