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 |
|
raguyazhin
Posting Yak Master
105 Posts |
 Posted - 2010-12-23 : 01:54:37
|
| Fill Factor Increase the DB Size?Exwhen Fill Factor is 100% then DB Size is 50 GB thenFill Factor is 50% then DB Size Will increase to 100 GB it's right?--Ragu ThangavelSQL Server Junior DBA |
|
|
Kristen
Test
22859 Posts |
Posted - 2010-12-23 : 05:29:51
|
| Index size will increase, not DB Size. (edit Well, increasing index WILL in crease DB size, but the DB is not 100% indexes, so doubling one index will not double the size of the whole database)There are arguments in favour of all indexes being 100% FILL - i.e. there is negligible gain from having any slack in the index but more often there is deterioration in performance. |
 |
|
|
|
|
|
Fill Factor