Solved

change index fillfactor

Posted on 2013-01-22
1
300 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

Get up to 2TB FREE CLOUD per backup license!

An exclusive Black Friday offer just for Expert Exchange audience! Buy any of our top-rated backup solutions & get up to 2TB free cloud per system! Perform local & cloud backup in the same step, and restore instantly—anytime, anywhere. Grab this deal now before it disappears!

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
SQL 2008 SSIS import 11 48
T-SQL:  Negative Numbering in CTE Is Not Working 2 27
Generate Weekly Schedule 15 13
Extract string portion 2 0
How to leverage one TLS certificate to encrypt Microsoft SQL traffic and Remote Desktop Services, versus creating multiple tickets for the same server.
For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…

948 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

21 Experts available now in Live!

Get 1:1 Help Now