Included index

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by Arup Chakraborty » Included index

21 posts, Page 1 of 3

1 2 3 »»»

Included index

Rate Topic

Display Mode

Topic Options

Author

Message

arup chakraborty

Posted Wednesday, November 12, 2008 9:13 PM

SSC-Addicted

Group: General Forum Members
Last Login: Tuesday, July 03, 2012 5:49 AM
Points: 418, Visits: 365

Comments posted to this topic are about the item Included index

Post #601832

ChiragNS

Posted Thursday, November 13, 2008 12:25 AM

SSCrazy

Group: General Forum Members
Last Login: Wednesday, April 24, 2013 5:02 AM
Points: 2,365, Visits: 1,825

i thought the third option was the right answer.

"Keep Trying"

Post #601877

David McKinney

Posted Thursday, November 13, 2008 12:46 AM

Mr or Mrs. 500

Group: General Forum Members
Last Login: Yesterday @ 7:52 AM
Points: 582, Visits: 1,603

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

jadawinwolff

Posted Thursday, November 13, 2008 1:30 AM

SSC Rookie

Group: General Forum Members
Last Login: Tuesday, January 08, 2013 4:41 AM
Points: 33, Visits: 56

i fell for it also. it's multiple choice and the question itself doesnt indicate this (answers 2 AND 3 are correct).

Post #601903

David McKinney

Posted Thursday, November 13, 2008 2:03 AM

Mr or Mrs. 500

Group: General Forum Members
Last Login: Yesterday @ 7:52 AM
Points: 582, Visits: 1,603

ok...fair enough. A bit of dumb on both sides!

Post #601910

EdVassie

Posted Thursday, November 13, 2008 2:29 AM

SSCrazy

Group: General Forum Members
Last Login: Wednesday, May 22, 2013 3:26 AM
Points: 2,621, Visits: 2,759

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.

Author: SQL Server FineBuild 1-click install and best practice configuration of SQL Server 2012, 2008 R2, 2008 and 2005. 25 March 2013: now over 23,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

Mighty

Posted Thursday, November 13, 2008 2:31 AM

SSCrazy

Group: General Forum Members
Last Login: Wednesday, May 22, 2013 8:33 AM
Points: 2,723, Visits: 987

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

Vladan

Posted Thursday, November 13, 2008 5:37 AM

SSCommitted

Group: General Forum Members
Last Login: Thursday, May 05, 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

MG-148046

Posted Thursday, November 13, 2008 6:27 AM

SSCommitted

Group: General Forum Members
Last Login: Yesterday @ 6:17 AM
Points: 1,625, Visits: 1,926

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

Andy Lennon

Posted Thursday, November 13, 2008 7:11 AM

Ten Centuries

Group: General Forum Members
Last Login: Tuesday, August 07, 2012 6:59 AM
Points: 1,386, Visits: 823

i saw the 2008 in the question and didn't read option 2 closely enough.
Dirty tricks! :P

Post #602082

« Prev Topic | Next Topic »

21 posts, Page 1 of 3

1 2 3 »»»

Permissions