Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Indexed views Expand / Collapse
Author
Message
Posted Monday, June 8, 2009 11:10 PM
SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Thursday, December 11, 2014 5:11 AM
Points: 654, Visits: 267
Comments posted to this topic are about the item Indexed views
Post #731128
Posted Tuesday, June 9, 2009 3:50 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Wednesday, October 15, 2014 8:29 AM
Points: 2,158, Visits: 106
Good question, but I think, that cost of this question could be higher
Post #731275
Posted Tuesday, June 9, 2009 3:59 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, November 26, 2013 5:47 AM
Points: 1,065, Visits: 245
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
Post #731284
Posted Tuesday, June 9, 2009 8:06 AM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Monday, November 10, 2014 12:05 PM
Points: 3,969, Visits: 3,648
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.
Post #731462
Posted Tuesday, June 9, 2009 9:41 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, December 10, 2014 10:54 AM
Points: 135, Visits: 768
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...

[url=http://msdn.microsoft.com/en-us/library/ms191432.aspx][/url]

Post #731578
Posted Tuesday, June 9, 2009 11:49 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Yesterday @ 2:36 PM
Points: 2,850, Visits: 1,165
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.



Post #731745
Posted Thursday, July 29, 2010 7:38 AM
Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: Tuesday, September 23, 2014 6:09 AM
Points: 697, Visits: 356
I successfully created a view that already contain a image column.
what i say about your answer selection?
Post #960709
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse