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 123»»»

Included index Expand / Collapse
Author
Message
Posted Wednesday, November 12, 2008 9:13 PM


SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Tuesday, July 3, 2012 5:49 AM
Points: 418, Visits: 365
Comments posted to this topic are about the item Included index
Post #601832
Posted Thursday, November 13, 2008 12:25 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Tuesday, July 15, 2014 4:53 AM
Points: 2,366, Visits: 1,844
i thought the third option was the right answer.

"Keep Trying"
Post #601877
Posted Thursday, November 13, 2008 12:46 AM
SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Wednesday, August 20, 2014 4:39 AM
Points: 646, Visits: 1,861
yeah, me too. I don't get it!

Plus the question is wierd, as they're a 2005 feature. And answer 2 makes no sense, given the question.

But it is early....so maybe I've missed something dumb!
Post #601890
Posted Thursday, November 13, 2008 1:30 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Saturday, October 19, 2013 8:21 AM
Points: 33, Visits: 58
i fell for it also. it's multiple choice and the question itself doesnt indicate this (answers 2 AND 3 are correct).


Post #601903
Posted Thursday, November 13, 2008 2:03 AM
SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Wednesday, August 20, 2014 4:39 AM
Points: 646, Visits: 1,861
ok...fair enough. A bit of dumb on both sides!
Post #601910
Posted Thursday, November 13, 2008 2:29 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Yesterday @ 6:18 AM
Points: 2,869, Visits: 3,210
The question was 'What are included columns in SQL Server 2008'. I don't see that the status of included columns in SQL Server 2005 is relevant to the question.
If the question just said 'What are included columns in SQL Server' then options 2 and 3 are correct, but IMHO only 3 is right for the question as asked.


Original author: SQL Server FineBuild 1-click install and best practice configuration of SQL Server 2014, 2012, 2008 R2, 2008 and 2005. 28 July 2014: now over 30,000 downloads.
Disclaimer: All information provided is a personal opinion that may not match reality.
Concept: "Pizza Apartheid" - the discrimination that separates those who earn enough in one day to buy a pizza if they want one, from those who can not.
Post #601917
Posted Thursday, November 13, 2008 2:31 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: Wednesday, August 20, 2014 8:22 AM
Points: 3,230, Visits: 1,257
Answer should be C.
Even though it is not a new feature in 2008, it still is what it is (non key columns included...).
Post #601918
Posted Thursday, November 13, 2008 5:37 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Thursday, May 5, 2011 1:38 AM
Points: 1,636, Visits: 604
IMHO the problem is not whether it 2 or 3 is correct, but what is the answer 3?

If you read the "Sorry you were wrong" message, you!ll see that it gives
"A new feature in SQL Server 2005, non key columns included in addition to the index key columns in an index structure."
as correct answer.
When replying to the question, you are offered:
2. A new feature in SQL Server 2005
3. non key columns included in addition to the index key columns in an index structure


That means, answer 2 was incorrectly entered by the author - part of it is offered as answer 2 and part as answer 3 - while answer 3 was not entered at all and no one knows what it was. (BTW, If you look at the answer 3, you might notice that it starts with a small letter, not capital.)



Post #602009
Posted Thursday, November 13, 2008 6:27 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: 2 days ago @ 1:50 PM
Points: 1,804, Visits: 2,180
Looks like someone goofed on this one ;)

MG

"There are two ways of constructing a software design. One way is to make it so simple that there are obviously no deficiencies. And the other way is to make it so complicated that there are no obvious deficiencies."
Tony Hoare

"If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair.

Post #602033
Posted Thursday, November 13, 2008 7:11 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Monday, May 12, 2014 1:27 PM
Points: 1,386, Visits: 824
i saw the 2008 in the question and didn't read option 2 closely enough.
Dirty tricks! :P
Post #602082
« Prev Topic | Next Topic »

Add to briefcase 123»»»

Permissions Expand / Collapse