<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 Brandie Tarvin
»
Know Your SQL Objects
85 posts, Page 1 of 9
1
2
3
4
5
»
»»
Know Your SQL Objects
Rate Topic
Display Mode
Topic Options
Author
Message
Brandie Tarvin
Brandie Tarvin
Posted Thursday, May 12, 2011 11:19 PM
SSCertifiable
Group: General Forum Members
Last Login: Today @ 10:58 AM
Points: 6,655,
Visits: 5,678
Comments posted to this topic are about the item
Know Your SQL Objects
Brandie Tarvin, MCITP Database Administrator, MCDBA, MCSA
Webpage
:
http://www.BrandieTarvin.net
LiveJournal Blog
:
http://brandietarvin.livejournal.com/
On
LinkedIn!
,
Google+
, and
Twitter
.
Freelance Writer:
Shadowrun
Latchkeys: Nevermore
,
Latchkeys: The Bootleg War
, and
Latchkeys: Roscoes in the Night
are now available on Nook and Kindle.
Post #1108200
free_mascot
free_mascot
Posted Thursday, May 12, 2011 11:51 PM
SSCommitted
Group: General Forum Members
Last Login: Wednesday, April 17, 2013 3:39 AM
Points: 1,768,
Visits: 1,312
Good question!!!
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
Post #1108207
Danny Ocean
Danny Ocean
Posted Friday, May 13, 2011 12:06 AM
Ten Centuries
Group: General Forum Members
Last Login: Today @ 8:10 AM
Points: 1,078,
Visits: 1,144
Learn new thing.. thx
Keep Learning - Keep Growing !!!
http://growwithsql.blogspot.in
Thanks
Vinay Kumar
Post #1108209
srikant maurya
srikant maurya
Posted Friday, May 13, 2011 12:10 AM
SSC Eights!
Group: General Forum Members
Last Login: Yesterday @ 6:32 AM
Points: 925,
Visits: 996
Easy but tricky question,
Srikant
Post #1108210
Nils Gustav Stråbø
Nils Gustav Stråbø
Posted Friday, May 13, 2011 1:26 AM
SSCommitted
Group: General Forum Members
Last Login: Thursday, May 16, 2013 3:44 PM
Points: 1,786,
Visits: 3,323
Good question, but I thing the answer options are a little confusing.
"-Extents can be owned by multiple objects"
True, mixed extents.
"-Rows can span multiple pages (excluding LOB data)"
True. Row-overflow.
"-Extents can be owned by only one object"
False, since they can be a mixed extent (or even an extent that has not been allocated). Perhaps it's your use of the word "only" that confuses me, but what I read is "an extent must be owned by one, and only one, object."
"-Data pages can be owned by multiple objects"
False, obviously.
"-Text data is stored on data pages."
Do you mean text as in the datatype text, or as in text/strings? If you mean text as the text datatype, which makes this answer false, then please write so. If you mean text as in all data types that can store strings, then this answer is true.
"-Data pages can be owned by only one object"
True. One and only one object can use a data page. And when you compare the extent vs data page answers, you see why I'm confused.
"-A table row can be bigger than 8060 bytes if some of the datatypes are variable"
True. Again, row-overflow.
I don't care about the points, but I think some of the options were a little vague.
Or perhaps I'm just wrong
Post #1108222
Koen Verbeeck
Koen Verbeeck
Posted Friday, May 13, 2011 1:42 AM
SSCrazy Eights
Group: General Forum Members
Last Login: Today @ 7:39 AM
Points: 9,370,
Visits: 6,467
Nils Gustav Stråbø (5/13/2011)
"-Extents can be owned by only one object"
False, since they can be a mixed extent (or even an extent that has not been allocated). Perhaps it's your use of the word "only" that confuses me, but what I read is "an extent must be owned by one, and only one, object."
The question uses the word
can
, not
must
. If an extent can be owned by multiple objects, it can certainly be owned by one object.
Anyway, nice question, but only one point?
How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?
Member of
LinkedIn
. My blog at
LessThanDot
.
MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1108228
Chris Houghton
Chris Houghton
Posted Friday, May 13, 2011 1:54 AM
Mr or Mrs. 500
Group: General Forum Members
Last Login: Thursday, May 16, 2013 9:12 AM
Points: 557,
Visits: 1,356
Good question but the wording was a little ambiguous in my opinion. I learnt something though so I'm not complaining.
Post #1108234
Nils Gustav Stråbø
Nils Gustav Stråbø
Posted Friday, May 13, 2011 1:59 AM
SSCommitted
Group: General Forum Members
Last Login: Thursday, May 16, 2013 3:44 PM
Points: 1,786,
Visits: 3,323
@Koen, yes I agree that I should not have interpreted the word "can" as "must", but unfortunately I did
But the answer about text data is definitely ambiguous. Based on the "correct" answer it obviously related to the text datatype, not text data in general.
Post #1108236
mohammed moinudheen
mohammed moinudheen
Posted Friday, May 13, 2011 3:30 AM
SSCrazy
Group: General Forum Members
Last Login: Thursday, May 16, 2013 3:34 PM
Points: 2,170,
Visits: 3,582
Good question, I could get 3 options right :)
Mohammed Moinudheen
Post #1108267
John Mitchell-245523
John Mitchell-245523
Posted Friday, May 13, 2011 4:11 AM
SSCarpal Tunnel
Group: General Forum Members
Last Login: Today @ 8:51 AM
Points: 4,425,
Visits: 7,187
Koen Verbeeck (5/13/2011)
Nils Gustav Stråbø (5/13/2011)
"-Extents can be owned by only one object"
False, since they can be a mixed extent (or even an extent that has not been allocated). Perhaps it's your use of the word "only" that confuses me, but what I read is "an extent must be owned by one, and only one, object."
The question uses the word
can
, not
must
. If an extent can be owned by multiple objects, it can certainly be owned by one object.
Anyway, nice question, but only one point?
I'm with Nils on this. The sentence can be interpreted as "it is only possible for an extent to be owned by one object" or as "it is possible for an extent to be owned by only one object". I went for the former and so got it wrong. But, as has been pointed out, it's the discussion and what you learn that's important, not the points.
John
Post #1108288
« Prev Topic
|
Next Topic »
85 posts, Page 1 of 9
1
2
3
4
5
»
»»
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.
