Solved

change index fillfactor

Posted on 2013-01-22
1
298 Views
Last Modified: 2013-01-22
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
Comment
Question by:navajo26354
1 Comment
 
LVL 39

Accepted Solution

by:
lcohan earned 500 total points
Comment Utility
Yes if you do have ENTERPRISE edition you can use REBUILD with ONLINE=ON
0

Featured Post

Zoho SalesIQ

Hassle-free live chat software re-imagined for business growth. 2 users, always free.

Join & Write a Comment

Suggested Solutions

In this article I will describe the Detach & Attach method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

772 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now