Filtered Statistics

Question

Post reply

Filtered Statistics

Steve Jones - SSC Editor

SSC Guru

Points: 734418
More actions
May 2, 2019 at 12:00 am

#3385245

Comments posted to this topic are about the item Filtered Statistics

Viewing 15 posts - 1 through 14 (of 14 total)

You must be logged in to reply to this topic. Login to reply

SADSAC SSCrazy Points: 2327 More actions · Answer 1

Methinks there is a minor fail.

no options correct?

Good question, execution not so much

Christoph Muthmann Ten Centuries Points: 1127 More actions · Answer 2

I've chosen "Add a WHERE clause to your CREATE STATISTICS DDL", but all options are wrong. But the explanation is "You can use a WHERE clause with expression(s) just as you would for a filtered index."

Have a nice day,Christoph

DaveJenkins Mr or Mrs. 500 Points: 568 More actions · Answer 3

Same issue as last week; if I remember correctly it's not a high priority bug fix :(..

Shayn Thomas SSCertifiable Points: 5863 More actions · Answer 4

I think i got it right but just cant be sure :p

---------------------------------------------------------------------------------------
The more you know, the more you know that you dont know

paul s-306273 SSChampion Points: 10727 More actions · Answer 5

Oops. 100% wrong again!

Maybe I should answer later in the day.

Toni-256719 SSCertifiable Points: 5813 More actions · Answer 6

All answers show as incorrect. Since 79% of people chose the same response that I did, I'm going to assume that's the more accurate response out of the options.

Rune Bivrin SSCrazy Eights Points: 8438 More actions · Answer 7

Somewhere in the back of my head I hear Steve singing:

"Oops, I did it again"

Just because you're right doesn't mean everybody else is wrong.

call.copse SSCoach Points: 17958 More actions · Answer 8

CREATE STATISTICS BAD_QUESTIONS ON QUESTIONS WHERE CORRECT_ANSWER IS NULL

Is that about right? 🙂

Steve Jones - SSC Editor SSC Guru Points: 734418 More actions · Answer 9

Yeah, my fault. Didn't check the WHERE clause box as the answer. This new interface is a little tricky as I don't have a validation check and I can't see all answers at the same time, as I could before.

Andreas P. Williams SSCrazy Points: 2487 More actions · Answer 10

... and did those 124 who gave the correct answer get their point after all?

Stewart "Arturius" Campbell SSC Guru Points: 72486 More actions · Answer 11

Kinda makes me glad i was out of mobile range for a few days

____________________________________________
Space, the final frontier? not any more...
All limits henceforth are self-imposed.
“libera tute vulgaris ex”

Lempster SSCoach Points: 15651 More actions · Answer 12

Talking of the new interface, the only way I seem to be able to get back to the list of questions is to click on QotD in the menu bar, but then many of the questions I'd already answered (correctly or incorrectly) appear as unanswered, i.e. the 'Answer This' link is active. I'm using Chrome for my browser.

Am I doing something wrong?

Steve Jones - SSC Editor SSC Guru Points: 734418 More actions · Answer 13

Andreas P. Williams wrote:

... and did those 124 who gave the correct answer get their point after all?

Yes

Steve Jones - SSC Editor SSC Guru Points: 734418 More actions · Answer 14

Lempster wrote:

Talking of the new interface, the only way I seem to be able to get back to the list of questions is to click on QotD in the menu bar, but then many of the questions I'd already answered (correctly or incorrectly) appear as unanswered, i.e. the 'Answer This' link is active. I'm using Chrome for my browser. Am I doing something wrong?

Please post issues here, not in a discussion of another topic: https://www.sqlservercentral.com/forums/forum/sqlservercentral-com/sqlservercentral-com-website-issues