Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 


 
     
Recent Posts
   
Popular Topics
Home   
Search
    Members    Calendar    Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by VM » Indexed views
Add to briefcase

Indexed views Expand / Collapse
Rate Topic
Display Mode
Topic Options
Author
Message
VM-723206
Posted Monday, June 08, 2009 11:10 PM
SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Saturday, April 06, 2013 12:20 AM
Points: 649, Visits: 263
Comments posted to this topic are about the item Indexed views
Post #731128
dgvozdetsky
Posted Tuesday, June 09, 2009 3:50 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Wednesday, January 30, 2013 6:06 AM
Points: 1,685, Visits: 90
Good question, but I think, that cost of this question could be higher
Post #731275
Leo Hesen
Posted Tuesday, June 09, 2009 3:59 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, November 06, 2012 3:58 AM
Points: 1,065, Visits: 243
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
Cliff Jones
Posted Tuesday, June 09, 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: Tuesday, May 14, 2013 4:11 PM
Points: 3,390, Visits: 3,403
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
Scott Herrmann
Posted Tuesday, June 09, 2009 9:41 AM
SSC-Enthusiastic

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

Group: General Forum Members
Last Login: Thursday, May 16, 2013 10:32 AM
Points: 135, Visits: 700
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
Scott Coleman
Posted Tuesday, June 09, 2009 11:49 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Thursday, May 16, 2013 11:38 AM
Points: 2,818, Visits: 1,037
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
SQL Writer
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, August 28, 2012 4:29 AM
Points: 688, Visits: 311
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

 
 
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved. Privacy Policy. Terms of Use. Report Abuse.