September 10, 2013 at 6:17 pm
Hi ,
Some how SSMS Index Fillfactor Property is not saving Fillfactor settings.We have SQL server 2008 R2 .I checked server property ->Database Settings it is set to 0 or 100%.But when i go to table->index property it shows 70 %.I changed to 100,then went back to index property and it is back to 70.Any idea why SSMS is not saving changes?
September 10, 2013 at 6:29 pm
To quote someone smarter than I, "At an individual index level by specifying fillfactor when you create or rebuild the index."
Read this article: Brent Ozar's take on Fill Factor
September 10, 2013 at 6:48 pm
Well,when i rebuild index i specify fill factor(100).My question was why is it not saving .Also check the link that you pasted.It is creating copy of this(sqlcentral) page.
September 10, 2013 at 6:49 pm
Sorry about that...
http://www.brentozar.com/archive/2013/04/five-things-about-fillfactor/
If this is part of routine maintenance, did you check out Ola Hallengren's script? (It's here somewhere, and it works.)
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply