Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Table space usage 1


Table space usage 1

Author
Message
Mattrick
Mattrick
SSChasing Mays
SSChasing Mays (602 reputation)SSChasing Mays (602 reputation)SSChasing Mays (602 reputation)SSChasing Mays (602 reputation)SSChasing Mays (602 reputation)SSChasing Mays (602 reputation)SSChasing Mays (602 reputation)SSChasing Mays (602 reputation)

Group: General Forum Members
Points: 602 Visits: 767
Great question. I got it wrong, because my reading comprehension needs to improve. I saw the foreign keys, the question asked about an index that supports those foreign keys, and I incorrectly made an surmised that the question was assuming the indexes were present, even though they are not implicitly created by the statement. The mistake is mine. You are one of the few question providers whose questions I can take a face value, and I needed to do that here.

Thanks again, and I look forward to your next question.

Matt
Ernie Schlangen
Ernie Schlangen
SSCommitted
SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)

Group: General Forum Members
Points: 1782 Visits: 450
As noted in a previous discussion, I (almost) always look up the subject of the QOTD, due to the interesting little tidbits that I gain on the side. I did so again today, but happily my initial answers were correct (which is not always the case). Looking back, I don't think this was too difficult a question, but I am one of those whose initial reaction to a multiple-answer multiple choice question can't be repeated here. But I will admit that one generally has to understand a multiple-answer multiple choice question in order to be correct rather than simply deducing the correct choice as is often possible with single-answer multiple choice questions. Good question! Satisfied
jeff.mason
jeff.mason
Ten Centuries
Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)

Group: General Forum Members
Points: 1153 Visits: 2125
Yeah, in my case I am so used to the indexes being created as a part of making the foreign key that I failed to notice that they weren't part of creating the table here. So that was what caused me to miss this one.
Andre Guerreiro
Andre Guerreiro
Ten Centuries
Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)

Group: General Forum Members
Points: 1065 Visits: 1514
Thomas Abraham (11/9/2011)
Same here, including the part wrong. Forgot that primary key generates an index implicitly. Doh. Partial credit? :-)

Reminds me of my college days, when students would beg for "partial credit". One prof in the dept. would rant loudly, "Partial Credit! Partial Credit! Would you go to a doctor that always got partial credit?" w00t


Hahahaha, priceless! That's a smart teacher.

I really enjoyed the question as it was not too hard as it seemed at first look but we needed to pay attention to detail and lots of text.

Best regards,

Best regards,

Andre Guerreiro Neto

Database Analyst
http://www.softplan.com.br
MCITPx1/MCTSx2/MCSE/MCSA
Stewart "Arturius" Campbell
Stewart "Arturius" Campbell
SSCertifiable
SSCertifiable (5.8K reputation)SSCertifiable (5.8K reputation)SSCertifiable (5.8K reputation)SSCertifiable (5.8K reputation)SSCertifiable (5.8K reputation)SSCertifiable (5.8K reputation)SSCertifiable (5.8K reputation)SSCertifiable (5.8K reputation)

Group: General Forum Members
Points: 5775 Visits: 7130
Thanks for the question, Hugo
Looking forward to the next ones in the series...

____________________________________________
Space, the final frontier? not any more...
All limits henceforth are self-imposed.
“libera tute vulgaris ex”
Mike Dougherty-384281
Mike Dougherty-384281
Old Hand
Old Hand (316 reputation)Old Hand (316 reputation)Old Hand (316 reputation)Old Hand (316 reputation)Old Hand (316 reputation)Old Hand (316 reputation)Old Hand (316 reputation)Old Hand (316 reputation)

Group: General Forum Members
Points: 316 Visits: 944
Hugo Kornelis (11/9/2011)

I must say that the low rate of correct answers surprises me. I intended this question to be a relatively easy first question in a series (hence the "1" in the title). I have already submitted the second one, and I won't change that - but I'll have to rethink the difficulty level of the remaining planned questions (that I did not submit yet).


The number of ways of answering correctly: 1
The number of ways of answering incorrectly: many

The is no "partially correct" option. I might have complained about mixing 4 different ideas (and their negation) into the multiple-choice answer, but I thought "Grow up, these are professionals we're talking about" Smile So I'm sharing this thought to possibly explain why results are skewed to 9% correct.

I think there's also a psychological impact of 8 checkboxes - the answer seems simple enough, but then there's the second-guessing. After that first moment of hesitation, we're much less likely to check all (and only) the right boxes.

Anyway, I admit I was guessing at the answers - but I think this is a great example of an edge case of SQL ServerCentral Question of the Day. Maybe if more questions were written this way we'd be more accustomed to it?
Ken Wymore
Ken Wymore
SSCarpal Tunnel
SSCarpal Tunnel (4.4K reputation)SSCarpal Tunnel (4.4K reputation)SSCarpal Tunnel (4.4K reputation)SSCarpal Tunnel (4.4K reputation)SSCarpal Tunnel (4.4K reputation)SSCarpal Tunnel (4.4K reputation)SSCarpal Tunnel (4.4K reputation)SSCarpal Tunnel (4.4K reputation)

Group: General Forum Members
Points: 4420 Visits: 2342
Nice question Hugo. I got 3 out of 4 right and learned something so I'm happy with that.
Hugo Kornelis
Hugo Kornelis
SSCrazy Eights
SSCrazy Eights (8.3K reputation)SSCrazy Eights (8.3K reputation)SSCrazy Eights (8.3K reputation)SSCrazy Eights (8.3K reputation)SSCrazy Eights (8.3K reputation)SSCrazy Eights (8.3K reputation)SSCrazy Eights (8.3K reputation)SSCrazy Eights (8.3K reputation)

Group: General Forum Members
Points: 8321 Visits: 11554
Mike Dougherty-384281 (11/9/2011)
The number of ways of answering correctly: 1
The number of ways of answering incorrectly: many

The is no "partially correct" option. I might have complained about mixing 4 different ideas (and their negation) into the multiple-choice answer, but I thought "Grow up, these are professionals we're talking about" Smile So I'm sharing this thought to possibly explain why results are skewed to 9% correct.

I think there's also a psychological impact of 8 checkboxes - the answer seems simple enough, but then there's the second-guessing. After that first moment of hesitation, we're much less likely to check all (and only) the right boxes.

Anyway, I admit I was guessing at the answers - but I think this is a great example of an edge case of SQL ServerCentral Question of the Day. Maybe if more questions were written this way we'd be more accustomed to it?

I know multiple-answers questions are not the most popular, but in this case there are four obviously mutually exclusive answer pairs, so you are basically facing four yes/no questions combined into one question. I thought that would not be overly hard. Apparently, I was wrong. :-) (It's also intrigueing that for none of the yes/no pairs, the answers given add up to 100% - obviously, there are people who overlook both the "choose 4" in the question and the fact that the options are mutually exclusive so that there have to be four correct answers.

FWIW, the second question in this series will be a single-answer one (albeit with no less than seven options to choose from), and I just submitted the third question as a simple Yes/No question. I'll keep the rest on hold until I know how the second one is received, so that I can adjust the difficulty as needed.


Hugo Kornelis, SQL Server MVP
Visit my SQL Server blog: http://sqlblog.com/blogs/hugo_kornelis
Toreador
Toreador
SSCrazy
SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)

Group: General Forum Members
Points: 2413 Visits: 8062
Hugo Kornelis (11/9/2011)
So it is not only, as you say, reasonable to assume that the question is about space for the table being discussed - it is explicitly stated!


That still didn't stop me make the assumption that it was referring to the other table...Blush
Dave62
Dave62
Hall of Fame
Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)

Group: General Forum Members
Points: 3050 Visits: 2714
Hugo Kornelis (11/9/2011)
... Advance warning as a special service for those who take the time to read the discussion - the next question in this series (scheduled to go live in about a week) will involve some heavy arithmetic!

Oh great, just when we start getting the question authors trained to not turn us into human SQL parsers. Now we have to train them not to turn us into human calculators!!!

Just kidding. :-P

Keep the great questions coming Hugo!
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search