Prev: Date switch
Next: fill factor
From: Ajay on 4 Jul 2008 07:54
i am agree with the above details but i am getting little bit confused..

can u please tell me ...if i assigned fill factor 70% then what abt 30%

My confusion

1. 30% will be used for insertion and updation process only. is it never holds the data. if new data stored in 30% area than when page is going to split.

2. is it true each table can contain only one data page ?

if yes ..than what abt data page size ?



From: Tibor Karaszi on 4 Jul 2008 08:28
Fillfactor is only applied when the index is built (or re-built). After that, the pages will fill up
as they are destination pages for new rows. See
http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/ss2kidbp.mspx for a good
backgrounder.

Page size is 8 kByte. You can definitely have more than one page per table and index. Check out the
section about "Physical database architecture" in Books Online for details.

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi


"Ajay Choudhary" wrote in message news:20087475457ajjupatna(a)yahoo.com...
>i am agree with the above details but i am getting little bit confused..
>
> can u please tell me ...if i assigned fill factor 70% then what abt 30%
>
> My confusion
>
> 1. 30% will be used for insertion and updation process only. is it never holds the data. if new
> data stored in 30% area than when page is going to split.
>
> 2. is it true each table can contain only one data page ?
>
> if yes ..than what abt data page size ?
>
>
>

From: Dan Guzman on 4 Jul 2008 09:06
> can u please tell me ...if i assigned fill factor 70% then what abt 30%
>
> My confusion
>
> 1. 30% will be used for insertion and updation process only. is it never
> holds the data. if new data stored in 30% area than when page is going to
> split.

The FILLFACTOR applies only when the index is created. The 30% free space
can be used for new/expanded data and will avoid page splits until the page
becomes full. Note that the free space will increase storage requirements
and can decrease read performance so it should be specified judiciously.
See the Books Online for details.

> 2. is it true each table can contain only one data page ?
>

A table can contain zero or more pages and is limited only by available
storage. Table storage is allocated in units of 8 page (64K) extents.
The first page of a table is created in a mixed extent (shared with other
tables) and subsequent pages are allocated in dedicated extents (not
shared). This allocated technique reduces space requirements of small
tables while efficiently handling larger tables as well.

> if yes ..than what abt data page size ?

The page size is 8K (8192 bytes) in SQL Server.


--
Hope this helps.

Dan Guzman
SQL Server MVP
http://weblogs.sqlteam.com/dang/

"Ajay Choudhary" wrote in message news:20087475457ajjupatna(a)yahoo.com...
>i am agree with the above details but i am getting little bit confused..
>
> can u please tell me ...if i assigned fill factor 70% then what abt 30%
>
> My confusion
>
> 1. 30% will be used for insertion and updation process only. is it never
> holds the data. if new data stored in 30% area than when page is going to
> split.
>
> 2. is it true each table can contain only one data page ?
>
> if yes ..than what abt data page size ?
>
>
>

 | 
Pages: 1
Prev: Date switch
Next: fill factor