Post reply

Indexing Lookups

  • February 2, 2011 at 8:44 pm

    #63830

    Comments posted to this topic are about the item Indexing Lookups

  • February 2, 2011 at 8:45 pm

    #1281700

    Thanks for the question. I was the first to take this today. 🙂 Got 2 points.

    M&M

  • February 3, 2011 at 12:30 am

    #1281743

    Great question!

    I first didn't see the important words "in a table with a clustered index", so I ruled out the correct answer. Because the other answers didn't seem plausible, I decided to re-read the question 🙂

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • February 3, 2011 at 1:48 am

    This was removed by the editor as SPAM

  • February 3, 2011 at 1:56 am

    #1281758

    Thanks for the question! Nice and easy if you know the internals of indexes, and hopefully it will trigger the urge to learn more for those who answered it wrong.

  • February 3, 2011 at 2:28 am

    #1281770

    Great question!

    I'm surprised (and, frankly, disappointed) about the large percentage of incorrect answers, though.

    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/

  • February 3, 2011 at 2:33 am

    #1281771

    Hugo Kornelis (2/3/2011)

    Great question!

    I'm surprised (and, frankly, disappointed) about the large percentage of incorrect answers, though.

    Especially considering the "reprint" of Gail's excellent articles on the subject recently...

  • February 3, 2011 at 5:15 am

    #1281827

    I am one who selected a wrong answer because I did not remember the following found at what I think may be a better link for this question

    'If the table has a clustered index, or the index is on an indexed view, the row locator is the clustered index key for the row. '

    at http://msdn.microsoft.com/en-us/library/ms177484.aspx .

    Overall I hate not getting the right answer, but I must admit it was a well thought out question and truly made me have to think, especially after I found I selected the wrong answer.:-D

    Rick Karpel

  • February 3, 2011 at 5:40 am

    #1281843

    Thanks again Gail. Your 3-part article solidified me on this answer.

  • February 3, 2011 at 6:54 am

    #1281884

    Good question... Proves you need to read the question completely before you answer. I didn't read the part that says in a table with a clustered index

  • February 3, 2011 at 7:38 am

    #1281901

    Hugo Kornelis (2/3/2011)

    Great question!

    I'm surprised (and, frankly, disappointed) about the large percentage of incorrect answers, though.

    yes, it's a good questiopn. And yes, that half of the answers are incorrect is both surprising and disappointing - if fact I think it's appalling.

    Tom

  • February 3, 2011 at 8:45 am

    #1281952

    Super question!

  • February 3, 2011 at 8:51 am

    #1281958

    [font="Verdana"]Good question. I am glad that I got it right! Although surprised to see many incorrect answers…[/font]

  • February 3, 2011 at 8:59 am

    #1281966

    Richard M Karpel (2/3/2011)

    [/i] http://msdn.microsoft.com/en-us/library/ms177484.aspx

    Richard this was the same article I used to verify my answer.

    The Tables and Index Data Structures Architecture sections of the SQL 2008<R2> BOL is a must read.

    There is too much good information on how things are now in SQL server. 😎

  • February 3, 2011 at 9:11 am

    #1281978

    I really liked this question. (Hey, I got one right! :-P)

    Overall, I like all your questions Steve. Yes, more like this.

    The greatest enemy of knowledge is not ignorance, it is the illusion of knowledge. - Stephen Hawking

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

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