[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 315
  • Last Modified:

change index fillfactor

I have an index file group that is filling up a disk drive.  The fill factor is set to 80%.  I also have a job that rebuilds these indexes when the fragmentation gets beyond a certain percentage.  I want to change the fill factor so the index size will decrease.  Is this something that can be done without having to drop and recreate the entire index?
0
navajo26354
Asked:
navajo26354
1 Solution
 
lcohanDatabase AnalystCommented:
Yes if you do have ENTERPRISE edition you can use REBUILD with ONLINE=ON
0

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

Tackle projects and never again get stuck behind a technical roadblock.
Join Now