<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Recent Posts
Recent Posts
Popular Topics
Popular Topics
Home
Search
Members
Calendar
Who's On
Home
»
Article Discussions
»
Article Discussions by Author
»
Discuss content posted by Arup Chakraborty
»
Included index
21 posts, Page 2 of 3
««
1
2
3
»»
Included index
Rate Topic
Display Mode
Topic Options
Author
Message
mtassin
mtassin
Posted Thursday, November 13, 2008 7:38 AM
Hall of Fame
Group: General Forum Members
Last Login: Today @ 8:46 AM
Points: 3,226,
Visits: 64,166
Both 2 and 3 are correct.
These days it's very important to know when features were introduced. Include wasn't an option pre-2005. What it does is part 3.
Check boxes mean that there are possibly more than 1 correct answer and you need to select all of them. It's no better or worse than Microsoft certifications with multiple choice questions where multiple answers may be correct.
--Mark Tassin
MCITP - SQL Server DBA
Proud member of the Anti-RBAR alliance.
For help with Performance click this link
For tips on how to post your problems
Post #602113
george sibbald
george sibbald
Posted Thursday, November 13, 2008 7:44 AM
SSCertifiable
Group: General Forum Members
Last Login: Today @ 7:24 AM
Points: 5,267,
Visits: 11,198
If the question is 'what are included columns in 2008', I don't see how 'a new feature introduced in 2005' can be part of the answer. It might be a correct statement but its not an answer to the question as asked.
---------------------------------------------------------------------
Post #602119
mtassin
mtassin
Posted Thursday, November 13, 2008 7:53 AM
Hall of Fame
Group: General Forum Members
Last Login: Today @ 8:46 AM
Points: 3,226,
Visits: 64,166
And that's where I would disagree. Included columns in 2008 are a feature that was introduced in 2005. They're nothing new to it.
--Mark Tassin
MCITP - SQL Server DBA
Proud member of the Anti-RBAR alliance.
For help with Performance click this link
For tips on how to post your problems
Post #602127
Steve Jones - SSC Editor
Steve Jones - SSC Editor
Posted Thursday, November 13, 2008 8:02 AM
SSC-Dedicated
Group: Administrators
Last Login: Today @ 9:00 AM
Points: 31,410,
Visits: 13,728
I can see where the question is a little ambiguously worded. I shall add a "select all" and award back points to people for this one.
Follow me on Twitter:
@way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
Post #602145
Lynn Pettis
Lynn Pettis
Posted Thursday, November 13, 2008 10:35 AM
SSC-Insane
Group: General Forum Members
Last Login: Today @ 8:59 AM
Points: 21,598,
Visits: 27,418
Steve Jones - Editor (11/13/2008)
I can see where the question is a little ambiguously worded. I shall add a "select all" and award back points to people for this one.
Slightly off-topic, but on the Member scores and standings page, my points don't match between Question of the Day and Question of the Day Breakdown. My points in the Breakdown section is higher the Question of the Day section.
Lynn Pettis
For better assistance in answering your questions, click here
For tips to get better help with Performance Problems, click here
For Running Totals and its variations, click here
or
when working with partitioned tables
For more about Tally Tables, click here
For more about Cross Tabs and Pivots, click here
and
here
Managing Transaction Logs
SQL Musings from the Desert
Fountain Valley SQL
(My Mirror Blog)
Post #602263
Chad Crawford
Chad Crawford
Posted Thursday, November 13, 2008 12:13 PM
SSCrazy
Group: General Forum Members
Last Login: Yesterday @ 4:52 PM
Points: 2,548,
Visits: 17,353
Check boxes mean that there are possibly more than 1 correct answer and you need to select all of them. It's no better or worse than Microsoft certifications with multiple choice questions where multiple answers may be correct.
I hate to spill the beans (Steve, wipe this out if you want), but if you see checkboxes on the QOD it always means there is more than one answer. When you put in a QOD, you check the answers that are correct. If you pick only one as correct, it displays radio buttons. If you pick multiple, it will use check boxes. So... if you see check boxes, always select at least two answers...
:)
Chad
Post #602313
Jack Corbett
Jack Corbett
Posted Thursday, November 13, 2008 2:03 PM
SSChampion
Group: General Forum Members
Last Login: Friday, May 17, 2013 12:22 PM
Points: 10,571,
Visits: 11,871
Chad Crawford (11/13/2008)
Check boxes mean that there are possibly more than 1 correct answer and you need to select all of them. It's no better or worse than Microsoft certifications with multiple choice questions where multiple answers may be correct.
I hate to spill the beans (Steve, wipe this out if you want), but if you see checkboxes on the QOD it always means there is more than one answer. When you put in a QOD, you check the answers that are correct. If you pick only one as correct, it displays radio buttons. If you pick multiple, it will use check boxes. So... if you see check boxes, always select at least two answers...
:)
Chad
I don't disagree Chad, but I do agree with the others who read the question and, seeing SQL 2008 in the question, ignored the SQL 2005 answer as I did as well.
Jack Corbett
Applications Developer
Don't let the good be the enemy of the best. --
Paul Fleming
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
How to Post Performance Problems
Crosstabs and Pivots or How to turn rows into columns Part 1
Crosstabs and Pivots or How to turn rows into columns Part 2
Post #602389
arup chakraborty
arup chakraborty
Posted Friday, November 14, 2008 6:10 AM
SSC-Addicted
Group: General Forum Members
Last Login: Tuesday, July 03, 2012 5:49 AM
Points: 418,
Visits: 365
Hi All,
I have seen this question created a lot of confusion. Here is a humble explanation.
My question was "'What are included columns in SQL Server 2008?"
There is no difference of included index in SQL Server 2005 and SQL Server 2008. Hence, the question is clear. The answer, whatever it is, applies to both SQL Server 2005 and 2008.
I am not discussing the first answer. The second answer was "This is a new feature of SQL Server 2005". This statement is correct because SQL Server 2005 introduced it and SQL Server 2008 just kept the feature same.
The third answer is the actual definition, hence correct.
This two out of three is correct, hence the check boxes are used.
I have tried to make the flat question a tricky one. I am really sorry if there is still any ambiguity.
Cheers...
Post #602660
ChrisMoix-87856
ChrisMoix-87856
Posted Friday, November 14, 2008 11:44 AM
SSC Eights!
Group: General Forum Members
Last Login: Wednesday, April 03, 2013 8:23 AM
Points: 966,
Visits: 927
The third choice is still a little ambiguous. From BOL:
Specifies the nonkey columns to be added to the leaf level of the nonclustered index. The nonclustered index can be unique or nonunique.
The third choice:
non key columns included in addition to the index key columns in an index structure
...makes it sound like they are included in the whole index tree, not just the leaf level.
Post #602991
Tom Brown
Tom Brown
Posted Tuesday, November 25, 2008 3:20 AM
Ten Centuries
Group: General Forum Members
Last Login: Tuesday, May 14, 2013 5:16 AM
Points: 1,196,
Visits: 1,319
Trick question!
- how about some recognition for getting it partly right?
Post #608193
« Prev Topic
|
Next Topic »
21 posts, Page 2 of 3
««
1
2
3
»»
Permissions
You
cannot
post new topics.
You
cannot
post topic replies.
You
cannot
post new polls.
You
cannot
post replies to polls.
You
cannot
edit your own topics.
You
cannot
delete your own topics.
You
cannot
edit other topics.
You
cannot
delete other topics.
You
cannot
edit your own posts.
You
cannot
edit other posts.
You
cannot
delete your own posts.
You
cannot
delete other posts.
You
cannot
post events.
You
cannot
edit your own events.
You
cannot
edit other events.
You
cannot
delete your own events.
You
cannot
delete other events.
You
cannot
send private messages.
You
cannot
send emails.
You
may
read topics.
You
cannot
rate topics.
You
cannot
vote within polls.
You
cannot
upload attachments.
You
may
download attachments.
You
cannot
post HTML code.
You
cannot
edit HTML code.
You
cannot
post IFCode.
You
cannot
post JavaScript.
You
cannot
post EmotIcons.
You
cannot
post or upload images.
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
