Indexed views

  • Comments posted to this topic are about the item Indexed views

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

  • 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

  • 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.

  • 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...

  • 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.

  • 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