Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ramdas
Posting Yak Master
181 Posts |
 Posted - 2002-09-10 : 22:40:48
|
| Hi,If you find out that the number of page splits is high, consider increasing the fillfactor of your indexes. Why this so? What does a fill factor of 50 mean as compared to a fillfactor of 80. How is one better than the other in case of page splits.ByeRamdasRamdas NarayananSQL Server DBA |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2002-09-10 : 23:54:19
|
| If you look in Books Online under "fill factor" you'll find an excellent explanation of page splits and fill factor. Also look under DBCC SHOWCONTIG and DBCC DBREINDEX. |
 |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2002-09-11 : 07:10:40
|
| When a page is full it will be split into 2 so slowing down the insert/update and fragmenting the table.The fill factor specifies how full each index page should be on index creation.The lower the fill factor the more space available, less likely to page split but needs more reads to access.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
|
|
|
Page Splits