|
Home > Archive > microsoft.public.cert.mcdba > June 2002 > 70-229 Question
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
|
|
| Sam Smith 2002-06-23, 6:15 am |
| In my current textbook (MCDBA SQL Server 2000 Database Design, by Osborne),
it tells me that a page, including its 96byte header is 8,192 bytes. It then
tells me that becasue of this the maximum size for a row is 8,060 bytes. Is
it just me or does 8060 and 96 not add to 8192.
Can anybody give me a clue whats wrong here?
thanks
Sam
| |
| Sue Hoegemeier 2002-06-23, 6:15 am |
| It's not accounting for all bytes as you also need space on the
page for the row offset table at the end of the page.
-Sue
On Thu, 9 May 2002 11:55:04 +1200, "Sam Smith"
<ses39sam123@yahoo.com> wrote:
>In my current textbook (MCDBA SQL Server 2000 Database Design, by Osborne),
>it tells me that a page, including its 96byte header is 8,192 bytes. It then
>tells me that becasue of this the maximum size for a row is 8,060 bytes. Is
>it just me or does 8060 and 96 not add to 8192.
>
>Can anybody give me a clue whats wrong here?
>
>thanks
>
>Sam
>
| |
| Sam Smith 2002-06-23, 6:15 am |
| it probably doesn't matter for the exam, but i'd like to know. Is the row
offset table 36 bytes?
"Sue Hoegemeier" <Sue_H@nomail.please> wrote in message
news:9rfjdu003s4bfmaue4iigm2cr
meokm5pj5@4ax.com...
> It's not accounting for all bytes as you also need space on the
> page for the row offset table at the end of the page.
>
> -Sue
>
> On Thu, 9 May 2002 11:55:04 +1200, "Sam Smith"
> <ses39sam123@yahoo.com> wrote:
>
> >In my current textbook (MCDBA SQL Server 2000 Database Design, by
Osborne),
> >it tells me that a page, including its 96byte header is 8,192 bytes. It
then
> >tells me that becasue of this the maximum size for a row is 8,060 bytes.
Is
> >it just me or does 8060 and 96 not add to 8192.
> >
> >Can anybody give me a clue whats wrong here?
> >
> >thanks
> >
> >Sam
> >
>
| |
| Sue Hoegemeier 2002-06-23, 6:15 am |
| I don't know that I've ever seen an actual size documented
anywhere. I would guess it would be variable as it stores one
entry for each row on the page.
-Sue
On Thu, 9 May 2002 12:44:11 +1200, "Sam Smith"
<ses39sam123@yahoo.com> wrote:
>it probably doesn't matter for the exam, but i'd like to know. Is the row
>offset table 36 bytes?
>
>"Sue Hoegemeier" <Sue_H@nomail.please> wrote in message
> news:9rfjdu003s4bfmaue4iigm2cr
meokm5pj5@4ax.com...
>> It's not accounting for all bytes as you also need space on the
>> page for the row offset table at the end of the page.
>>
>> -Sue
>>
>> On Thu, 9 May 2002 11:55:04 +1200, "Sam Smith"
>> <ses39sam123@yahoo.com> wrote:
>>
>> >In my current textbook (MCDBA SQL Server 2000 Database Design, by
> Osborne),
>> >it tells me that a page, including its 96byte header is 8,192 bytes. It
> then
>> >tells me that becasue of this the maximum size for a row is 8,060 bytes.
> Is
>> >it just me or does 8060 and 96 not add to 8192.
>> >
>> >Can anybody give me a clue whats wrong here?
>> >
>> >thanks
>> >
>> >Sam
>> >
>>
>
| |
| Al Manint 2002-06-23, 6:15 am |
| But it would depend on the size of the row. They probably take the size of
the page, how many they can fit, and the size needed for the offset and
calculate that to have the max capacity of the page.
--Al
P.S. This is only a guess. 
"Sue Hoegemeier" <Sue_H@nomail.please> wrote in message
news:341kdus5chufapimc3d3d1c4p
qkcngf38j@4ax.com...
> I don't know that I've ever seen an actual size documented
> anywhere. I would guess it would be variable as it stores one
> entry for each row on the page.
>
> -Sue
>
> On Thu, 9 May 2002 12:44:11 +1200, "Sam Smith"
> <ses39sam123@yahoo.com> wrote:
>
> >it probably doesn't matter for the exam, but i'd like to know. Is the row
> >offset table 36 bytes?
> >
> >"Sue Hoegemeier" <Sue_H@nomail.please> wrote in message
> > news:9rfjdu003s4bfmaue4iigm2cr
meokm5pj5@4ax.com...
> >> It's not accounting for all bytes as you also need space on the
> >> page for the row offset table at the end of the page.
> >>
> >> -Sue
> >>
> >> On Thu, 9 May 2002 11:55:04 +1200, "Sam Smith"
> >> <ses39sam123@yahoo.com> wrote:
> >>
> >> >In my current textbook (MCDBA SQL Server 2000 Database Design, by
> >Osborne),
> >> >it tells me that a page, including its 96byte header is 8,192 bytes.
It
> >then
> >> >tells me that becasue of this the maximum size for a row is 8,060
bytes.
> >Is
> >> >it just me or does 8060 and 96 not add to 8192.
> >> >
> >> >Can anybody give me a clue whats wrong here?
> >> >
> >> >thanks
> >> >
> >> >Sam
> >> >
> >>
> >
>
| |
| Sue Hoegemeier 2002-06-23, 6:15 am |
| Size of the offset doesn't depend on the size of the row. The
offset doesn't store data, just the location on the page (how far
the first byte is from the start of the page).
-Sue
On Sat, 11 May 2002 15:36:32 -0500, "Al Manint"
<al_manint@~yahoodotcom~> wrote:
>But it would depend on the size of the row. They probably take the size of
>the page, how many they can fit, and the size needed for the offset and
>calculate that to have the max capacity of the page.
>
>--Al
>
>P.S. This is only a guess.
>
>"Sue Hoegemeier" <Sue_H@nomail.please> wrote in message
> news:341kdus5chufapimc3d3d1c4p
qkcngf38j@4ax.com...
>> I don't know that I've ever seen an actual size documented
>> anywhere. I would guess it would be variable as it stores one
>> entry for each row on the page.
>>
>> -Sue
>>
>> On Thu, 9 May 2002 12:44:11 +1200, "Sam Smith"
>> <ses39sam123@yahoo.com> wrote:
>>
>> >it probably doesn't matter for the exam, but i'd like to know. Is the row
>> >offset table 36 bytes?
>> >
>> >"Sue Hoegemeier" <Sue_H@nomail.please> wrote in message
>> > news:9rfjdu003s4bfmaue4iigm2cr
meokm5pj5@4ax.com...
>> >> It's not accounting for all bytes as you also need space on the
>> >> page for the row offset table at the end of the page.
>> >>
>> >> -Sue
>> >>
>> >> On Thu, 9 May 2002 11:55:04 +1200, "Sam Smith"
>> >> <ses39sam123@yahoo.com> wrote:
>> >>
>> >> >In my current textbook (MCDBA SQL Server 2000 Database Design, by
>> >Osborne),
>> >> >it tells me that a page, including its 96byte header is 8,192 bytes.
> It
>> >then
>> >> >tells me that becasue of this the maximum size for a row is 8,060
>bytes.
>> >Is
>> >> >it just me or does 8060 and 96 not add to 8192.
>> >> >
>> >> >Can anybody give me a clue whats wrong here?
>> >> >
>> >> >thanks
>> >> >
>> >> >Sam
>> >> >
>> >>
>> >
>>
>
| |
| Al Manint 2002-06-23, 6:15 am |
| Right - but the amount of them depends on how many rows that they can fit on
the page. Thus the size discussion.
--Al
"Sue Hoegemeier" <Sue_H@nomail.please> wrote in message
news:cid3euslgm7f7td0dib3ttqft
m2p05ddm8@4ax.com...
> Size of the offset doesn't depend on the size of the row. The
> offset doesn't store data, just the location on the page (how far
> the first byte is from the start of the page).
>
> -Sue
>
> On Sat, 11 May 2002 15:36:32 -0500, "Al Manint"
> <al_manint@~yahoodotcom~> wrote:
>
> >But it would depend on the size of the row. They probably take the size
of
> >the page, how many they can fit, and the size needed for the offset and
> >calculate that to have the max capacity of the page.
> >
> >--Al
> >
> >P.S. This is only a guess.
> >
> >"Sue Hoegemeier" <Sue_H@nomail.please> wrote in message
> > news:341kdus5chufapimc3d3d1c4p
qkcngf38j@4ax.com...
> >> I don't know that I've ever seen an actual size documented
> >> anywhere. I would guess it would be variable as it stores one
> >> entry for each row on the page.
> >>
> >> -Sue
> >>
> >> On Thu, 9 May 2002 12:44:11 +1200, "Sam Smith"
> >> <ses39sam123@yahoo.com> wrote:
> >>
> >> >it probably doesn't matter for the exam, but i'd like to know. Is the
row[c
olor=darkred]
> >> >offset table 36 bytes?
> >> >
> >> >"Sue Hoegemeier" <Sue_H@nomail.please> wrote in message
> >> > news:9rfjdu003s4bfmaue4iigm2cr
meokm5pj5@4ax.com...
> >> >> It's not accounting for all bytes as you also need space on the
> >> >> page for the row offset table at the end of the page.
> >> >>
> >> >> -Sue
> >> >>
> >> >> On Thu, 9 May 2002 11:55:04 +1200, "Sam Smith"
> >> >> <ses39sam123@yahoo.com> wrote:
> >> >>
> >> >> >In my current textbook (MCDBA SQL Server 2000 Database Design, by
> >> >Osborne),
> >> >> >it tells me that a page, including its 96byte header is 8,192[/color]
bytes.
> >It
> >> >then
> >> >> >tells me that becasue of this the maximum size for a row is 8,060
> >bytes.
> >> >Is
> >> >> >it just me or does 8060 and 96 not add to 8192.
> >> >> >
> >> >> >Can anybody give me a clue whats wrong here?
> >> >> >
> >> >> >thanks
> >> >> >
> >> >> >Sam
> >> >> >
> >> >>
> >> >
> >>
> >
>
| |
| Andrew John 2002-06-23, 6:15 am |
| Sam,
It's probably future use 'spares'.
Changing the pagesize or amount of data stored per page is
probably a 'Big Deal', hence the conservative allocation.
Regards
AJ
"Sam Smith" <ses39sam123@yahoo.com> wrote in message news TiC8.607$p77.66764@news.xtra.co.nz...
> In my current textbook (MCDBA SQL Server 2000 Database Design, by Osborne),
> it tells me that a page, including its 96byte header is 8,192 bytes. It then
> tells me that becasue of this the maximum size for a row is 8,060 bytes. Is
> it just me or does 8060 and 96 not add to 8192.
>
> Can anybody give me a clue whats wrong here?
>
> thanks
>
> Sam
>
>
|
|
|
|
|