Query about Pages & Extents - Newbie

HI,
Just got puzzled. Was going through SQL Arch. basics and
encountered about pages (8kb) and extents ( 8pg * 8kb).
somewhere it says *Transaction log space is not measured
in extents* . Could any one give details on how SQL pages
& extents concept is used differently on a database and
transaction log file?
Regards
ChipHi Chip
In the data files, the data is organized into tables and table pages are all
8KB. Space is allocated to a table in units of 8 pages (8 * 8 KB, or one
extent) at a time, so there is room for more rows to be added before more
allocation needs to be done. The new extents allocated to a table can can
from anywhere in the file, although SQL Server will try to find an extent
close by to existing extents for the table, wherever possible.
Log files are not organized into tables. Log records are just written to the
log file sequentially as transactions commit. No preallocation of space is
done for the log. It's just a record of the changes to your database.
--
HTH
--
Kalen Delaney
SQL Server MVP
www.SolidQualityLearning.com
"Chip" <anonymous@.discussions.microsoft.com> wrote in message
news:006f01c3d225$d0347eb0$a401280a@.phx.gbl...
> HI,
> Just got puzzled. Was going through SQL Arch. basics and
> encountered about pages (8kb) and extents ( 8pg * 8kb).
> somewhere it says *Transaction log space is not measured
> in extents* . Could any one give details on how SQL pages
> & extents concept is used differently on a database and
> transaction log file?
> Regards
> Chip|||Hi Kalen,
Thanks a Lot for the explanation. It was a gunshot.
Best Regards
Chip
>--Original Message--
>Hi Chip
>In the data files, the data is organized into tables and
table pages are all
>8KB. Space is allocated to a table in units of 8 pages (8
* 8 KB, or one
>extent) at a time, so there is room for more rows to be
added before more
>allocation needs to be done. The new extents allocated to
a table can can
>from anywhere in the file, although SQL Server will try
to find an extent
>close by to existing extents for the table, wherever
possible.
>Log files are not organized into tables. Log records are
just written to the
>log file sequentially as transactions commit. No
preallocation of space is
>done for the log. It's just a record of the changes to
your database.
>--
>HTH
>--
>Kalen Delaney
>SQL Server MVP
>www.SolidQualityLearning.com
>
>"Chip" <anonymous@.discussions.microsoft.com> wrote in
message
>news:006f01c3d225$d0347eb0$a401280a@.phx.gbl...
>> HI,
>> Just got puzzled. Was going through SQL Arch. basics and
>> encountered about pages (8kb) and extents ( 8pg * 8kb).
>> somewhere it says *Transaction log space is not measured
>> in extents* . Could any one give details on how SQL
pages
>> & extents concept is used differently on a database and
>> transaction log file?
>> Regards
>> Chip
>
>.
>

Q: where to find download of "SQL Query Analyzer"?

yup, another newbie Q <smile>
Q: where to find download of "SQL Query Analyzer"?
thanks in advance
howard_nyc@.yahoo.com
<<RE-POST>> <<RE-WORDED>>
yup, another newbie Q <smile>
Q: where to find download of "SQL Query Analyzer"?
since I am using MSDE there is no CD available to me... I would prefer
to download the SQL-QA utility
thanks in advance
howard_nyc@.yahoo.com
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!
|||You can't, it's not available separate from SQL Server and you are not
allowed to use it against an MADE database 99% of the time. Please have a
look at one of Aaron Bertrand's excellent Fads:
http://www.aspfaq.com/show.asp?id=2442. It includes a list of 3rd-party
applications that you can use.
Sincerely,
Stephen Dybing
This posting is provided "AS IS" with no warranties, and confers no rights.
"Howard Wertenteil" <howard_nyc@.yahoo.com> wrote in message
news:%23qccSwHjEHA.3696@.TK2MSFTNGP15.phx.gbl...
> <<RE-POST>> <<RE-WORDED>>
>
> yup, another newbie Q <smile>
> Q: where to find download of "SQL Query Analyzer"?
> since I am using MSDE there is no CD available to me... I would prefer
> to download the SQL-QA utility
> thanks in advance
> howard_nyc@.yahoo.com
> *** Sent via Developersdex http://www.codecomments.com ***
> Don't just participate in USENET...get rewarded for it!
|||Uh, MSDE database, not MADE database. :-)
Sincerely,
Stephen Dybing
This posting is provided "AS IS" with no warranties, and confers no rights.
"Stephen Dybing [MSFT]" <stephd@.online.microsoft.com> wrote in message
news:%23dMVPjIjEHA.3536@.TK2MSFTNGP10.phx.gbl...
> You can't, it's not available separate from SQL Server and you are not
> allowed to use it against an MADE database 99% of the time. Please have a
> look at one of Aaron Bertrand's excellent Fads:
> http://www.aspfaq.com/show.asp?id=2442. It includes a list of 3rd-party
> applications that you can use.
> --
> Sincerely,
> Stephen Dybing
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
> "Howard Wertenteil" <howard_nyc@.yahoo.com> wrote in message
> news:%23qccSwHjEHA.3696@.TK2MSFTNGP15.phx.gbl...
>
|||And FAQ not FAD<g>.
Andrew J. Kelly SQL MVP
"Stephen Dybing [MSFT]" <stephd@.online.microsoft.com> wrote in message
news:Op8n50IjEHA.1048@.tk2msftngp13.phx.gbl...
> Uh, MSDE database, not MADE database. :-)
> --
> Sincerely,
> Stephen Dybing
> This posting is provided "AS IS" with no warranties, and confers no
rights.[vbcol=seagreen]
> "Stephen Dybing [MSFT]" <stephd@.online.microsoft.com> wrote in message
> news:%23dMVPjIjEHA.3536@.TK2MSFTNGP10.phx.gbl...
a
>
|||Oh man... I'd like to blame an over zealous spell checker, but I don't think
I used one. :-)
Sincerely,
Stephen Dybing
This posting is provided "AS IS" with no warranties, and confers no rights.
"Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
news:ORUzSQJjEHA.644@.tk2msftngp13.phx.gbl...
> And FAQ not FAD<g>.
> --
> Andrew J. Kelly SQL MVP
>
> "Stephen Dybing [MSFT]" <stephd@.online.microsoft.com> wrote in message
> news:Op8n50IjEHA.1048@.tk2msftngp13.phx.gbl...
> rights.
> a
>