Auto growth on Index file
Posted on 2013-01-14
I have a index data file which is currently 160 GBs and is fifty percent used. It is on a 200 GB drive. I have an index rebuild job that checks for fragmentation and if it's above 80 % it will rebuild. Currently the file is growing but still continuing to have fifty percent space used. I do not want this file to grow to fill up the 200 GB drive. If I stop the auto growth and fix the file size to 160 GB, will it use the free space inside the file or will this create a problem?