Indexed views

Question

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

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

dgvozdetsky SSCrazy Points: 2464 More actions · Answer 1

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

Leo Hesen Ten Centuries Points: 1139 More actions · Answer 2

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: 10547 More actions · Answer 3

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: 219 More actions · Answer 4

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: 27452 More actions · Answer 5

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 More actions · Answer 6

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

what i say about your answer selection?