Solved

change index fillfactor

Posted on 2013-01-22
1
304 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
ID: 38806375
Yes if you do have ENTERPRISE edition you can use REBUILD with ONLINE=ON
0

Featured Post

Three Reasons Why Backup is Strategic

Backup is strategic to your business because your data is strategic to your business. Without backup, your business will fail. This white paper explains why it is vital for you to design and immediately execute a backup strategy to protect 100 percent of your data.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

In this article I will describe the Backup & Restore 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.
Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
Via a live example, show how to shrink a transaction log file down to a reasonable size.
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

803 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