You'll find plenty of scripts out there using sp_MSforeachdb.

It's really useful...

Perhaps we need some Quality Control on QOD.

Changing the question after people have started submitting answers - that seems a bit unfair to me...

Ron - I'd have thought QOD should be like asking for help in a forum. Make it esay for yourself to be understood.

As for posing a question, I don't actually...

This question was poorly presented.

I hope we don't see questions presented in this way again.

"have you tried switching if off and on again" (the last one is a joke, of course).

That does work sometimes!

I'd have thought some thought of verification would make sense.

Lighten up - surely it's all the other questions that are easy!

I had to 'Google' the answer...

🙂

How about Tom Kyte - he's one of the best!

RBAR - also known as 'slow-by-slow'.

Steve - excellent article. I've managed to learn most of the things you talk about but struggle with tuning. Do you have any suggestions for learning the fundamentals of tuning?

Greg - thanks for that; I've now set this up as a job as you've advised.

Greg - I want to DTS this because I've a training database that needs to be restored each evening ready for the next day's training. I thought I'd put everything...

John - thanks for that.

(Where are you supposed to find that out for yourself?!)

... yes, looks wrong to me as well.

Paul

Your very first observation is correct.

Answer to your question is no. (Advert_from (say 1-1-2006) is always less than advrt_to (say 2-2-2006).