Index Types

  • Dan Graveen (7/5/2012)


    I was wondering why the answers were checkboxes too and not just radio buttons. The answer is 10, I looked it up on msdn just to be sure. So where is 12 coming from??

    Yes, I knew I would get this one wrong when I saw the answers had checkboxes.

  • Steve Cullen (7/5/2012)


    Correct answers = 1 ???

    This must be one of those Monty Python type questions:

    Q: What is your name?

    A: Steve Cullen

    Q: What is your quest?

    A: I seek knowledge and wisdom about SQL Server.

    Q: How many index types in SQL 2012 are there?

    A: 10. No 12. AAAAAAAAAAAAAAAAAAAaaaHHHHHHHHHHHHHHHHHHHHHHHHHHH.................

    +10, no +12

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • Correct answers:3%(7)

    Incorrect answers:97%(262)

    Total attempts: 269

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • This one was a real stinker. Seems like MSDN thinks 10 is the correct answer too!!

  • I think SSC should filter out these type of questions from publishing...

    Regards,
    Ravi.

  • Wow this is truly is the worst type of question. You have to answer it correct according to BOL AND read the authors mind at the same time. Then come up with the completely ridiculous notion that a count can have two answers. I appreciate the effort by the author but this is just bad. It didn't teach anything and has generated one of the lowest percentage of correct answers to date.

    _______________________________________________________________

    Need help? Help us help you.

    Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

    Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.

    Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
    Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
    Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
    Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/

  • Correct answers: 2% (8)

    Incorrect answers: 98% (328)

    Total attempts: 336

    How did 8 people manage to get this one correct?

  • Sean Lange (7/5/2012)


    You have to answer it correct according to BOL AND read the authors mind at the same time.

    It's worse than that. The author said

    It can be argued that unique can go with clustered/nonclustered, as can includes, but for the sake of the question, we will go with the BOL answer.

    which I interpret to mean that answer would be 8...

  • Rich Weissler (7/5/2012)


    Sean Lange (7/5/2012)


    You have to answer it correct according to BOL AND read the authors mind at the same time.

    It's worse than that. The author said

    It can be argued that unique can go with clustered/nonclustered, as can includes, but for the sake of the question, we will go with the BOL answer.

    which I interpret to mean that answer would be 8...

    ROFL now we have 2 interpretations of mind reading going on. I think the author meant that you could have unique with both clustered and non-clustered. In fact if that means that unique clustered and unique non-clustered are in fact different index types (which is really quite ludicrous) the total would be 11 and not 12 because unique would not still be considered an index on its own. So we have proven beyond a doubt that the only correct answer possible is the old stand by "It Depends". I just have no idea exactly what it depends on...:w00t:

    _______________________________________________________________

    Need help? Help us help you.

    Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

    Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.

    Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
    Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
    Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
    Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/

  • Junk question.

    Cheers

  • twelve equals ten for large values of ten.

    I like that.

    Simone
  • Steve Cullen (7/5/2012)


    Correct answers = 1 ???

    This must be one of those Monty Python type questions:

    Q: What is your name?

    A: Steve Cullen

    Q: What is your quest?

    A: I seek knowledge and wisdom about SQL Server.

    Q: How many index types in SQL 2012 are there?

    A: 10. No 12. AAAAAAAAAAAAAAAAAAAaaaHHHHHHHHHHHHHHHHHHHHHHHHHHH.................

    A terrible question that were best removed from the site and forgotten soon - if not for the above post in the discussion, which makes up for everything! 😉

    Seriously. We had a similar question a few months back on the number of index types in SQL2008 or SQL2008R2. And while that one did not have two conflicting answers ticked, it did spur a lot of discussion because the whole subject is too much of a grey area.

    The list given in Books Online is far too vague. Some "types" are mutually exclusive, others are not. Various combinations are possible. If "unique", "nonclustered", "with included columns", "on computed columns" and "fitered" are seperate index types, than how about a unique nonclustered filtered index on computed columns and with included columns? How about an index on a combination of computed and non computed columns? How about an index that includes computed columns?

    And if minor variations on nonclustered indexes are counted as different types, then why are all types of xml indexes (primary, path seconday, value secondary, and property secondary) not counted?

    If you want to test knowledge of index types, you should include a list of existing and non-existing index types and let the reader pick the "correct" ones.

    (In fact, I think I am going to submit a few questions of that type right now!)


    Hugo Kornelis, SQL Server/Data Platform MVP (2006-2016)
    Visit my SQL Server blog: https://sqlserverfast.com/blog/
    SQL Server Execution Plan Reference: https://sqlserverfast.com/epr/

  • I don't know what was the intention of this question, but it shouldn't have been included here. Having 2 possible answers where it should only have one is just pathetic.

    "El" Jerry.

    "El" Jerry.

    "A watt of Ottawa" - Gerardo Galvan

    To better understand your help request, please follow these best practices.[/url]

  • I am all for multiple choice questions and do not necessarily need a hint to pick 2 or pick 3 but as someone mentioned before, a count cannot be more than one value. I thought I had an easy point today. Guess I better take up mind reading before I come back to answer more. 😀

  • I was wrong.

    Editor was right!

Viewing 15 posts - 31 through 45 (of 79 total)

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