Stats_ID

Question

Post reply

Stats_ID

Steve Jones - SSC Editor

SSC Guru

Points: 736172
More actions
July 12, 2018 at 8:33 pm

#77349

Comments posted to this topic are about the item Stats_ID

Viewing 6 posts - 1 through 5 (of 5 total)

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

Revenant SSC-Forever Points: 42467 More actions · Answer 1

Steve, it does not work for me. I got this one wrong; however, when I ran it in SSMS and checked, I got clearly 1.

Are you sure your answer is correct?

Stewart "Arturius" Campbell SSC Guru Points: 72624 More actions · Answer 2

Interesting,thanks Steve

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

Steve Jones - SSC Editor SSC Guru Points: 736172 More actions · Answer 3

Revenant - Friday, July 13, 2018 12:49 PM
Steve, it does not work for me. I got this one wrong; however, when I ran it in SSMS and checked, I got clearly 1.
Are you sure your answer is correct?

Are you checking for the PK or the clustered index? For the CX, it's one. In the question, the clustered index is on OrderDate, but the PK is OrderKey.

I get

Shayn Thomas SSCertifiable Points: 5863 More actions · Answer 4

Nice Question Steve,

Got it wrong I didn't read the question properly,

DOH!!

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

Revenant SSC-Forever Points: 42467 More actions · Answer 5

Steve Jones - SSC Editor - Monday, July 16, 2018 8:05 AM
Revenant - Friday, July 13, 2018 12:49 PM
Steve, it does not work for me. I got this one wrong; however, when I ran it in SSMS and checked, I got clearly 1.
Are you sure your answer is correct?
Are you checking for the PK or the clustered index? For the CX, it's one. In the question, the clustered index is on OrderDate, but the PK is OrderKey.
I get

Ah-hah! Thanks, Steve!