Indexed views

  • VM-723206

    SSCrazy

    Points: 2964

    Comments posted to this topic are about the item Indexed views

  • dgvozdetsky

    SSCrazy

    Points: 2464

    Good question, but I think, that cost of this question could be higher

  • Leo Hesen

    Ten Centuries

    Points: 1139

    So,

    One of the tricks was to see the difference between

    When you create a clustered or nonclustered index, the IGNORE_DUP_KEY option must be set to ON (the default setting).

    AND

    When you create a clustered or nonclustered index, the IGNORE_DUP_KEY option must be set to OFF (the default setting).

    At first sight I saw IGNORE_DUP_KEY and the default setting and my thought was: that is correct.

    So we have to check every word I guess 🙂

    Leo

  • Cliff Jones

    SSChampion

    Points: 10517

    dgvozdetsky (6/9/2009)


    Good question, but I think, that cost of this question could be higher

    I agree, especially with the spoiler on IGNORE_DUP_KEY which was bound to trip some people up. Good job on that.

  • Scott Herrmann

    SSC Veteran

    Points: 209

    A resource link for the correct answers was not included in the answer section. Here is one that will help you find out which one(s) were right...

  • Scott Coleman

    One Orange Chip

    Points: 27442

    Leo Hesen (6/9/2009)


    So we have to check every word I guess 🙂

    When I first saw the question, I knew it had "Trick Question" written all over it.

  • SQL Editor

    SSCommitted

    Points: 1980

    I successfully created a view that already contain a image column.

    what i say about your answer selection?

Viewing 7 posts - 1 through 7 (of 7 total)

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