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 |
|
vladimir_grigoro
Yak Posting Veteran
62 Posts |
 Posted - 2002-09-18 : 09:11:39
|
| Hi all,I have a table with over 4M records (SQL Server 2000). I have an uniqie clustered index on an int data type column. What kind of fill factor is better to use smaller (10..) or bigger (90..). I have to insert 50-60 000 new records per week in that table.Thanks.The Rebel |
|
|
lozitskiy
Starting Member
28 Posts |
Posted - 2002-09-18 : 09:28:00
|
| It depends on to what kind of database belongs your table – OLTP (I guess not) or warehouse. How frequently data is inserting to table (once a week, once a day or during of day)? What about updates?For OLTP it needs to set low level of fill factor. If it is warehouse, you add data to table once during of day or week (from OLTP) – set high level of fill factor.-------------MCP MSSQL |
 |
|
|
vladimir_grigoro
Yak Posting Veteran
62 Posts |
Posted - 2002-09-18 : 09:33:55
|
| I have one Insert per week around 50 60 thousand records and one update on all records.The Rebel |
|
|
|
chadmat
The Chadinator
1974 Posts |
Posted - 2002-09-18 : 12:40:28
|
| What is the read frequency? Is there a lot of 'select' statements on the DB?How often do you rebuild the indexes? -Chad |
|
|
|
|
|
|
Better prfomnace with fill factor