Morning all
I'm just woring through this and I've found a database where all the indexes have a fill factor of 0 (yup, zero).
Here's the output from the fill-factor query in the article (adjusted to collect all indexes):-
fill_factorobject_idnameindex_idtype_desc
08NULL0HEAP
0466100701NULL0HEAP
0469576711NULL0HEAP
0498100815NULL0HEAP
0514100872NULL0HEAP
0517576882NULL0HEAP
0530100929NULL0HEAP
0546100986NULL0HEAP
0562101043NULL0HEAP
0578101100NULL0HEAP
0594101157NULL0HEAP
0610101214NULL0HEAP
0626101271NULL0HEAP
0642101328NULL0HEAP
0658101385NULL0HEAP
0674101442NULL0HEAP
0690101499NULL0HEAP
0706101556NULL0HEAP
0722101613NULL0HEAP
0738101670NULL0HEAP
0754101727NULL0HEAP
0770101784NULL0HEAP
0786101841NULL0HEAP
0802101898NULL0HEAP
0818101955NULL0HEAP
0834102012NULL0HEAP
0850102069NULL0HEAP
0866102126NULL0HEAP
0882102183NULL0HEAP
0898102240NULL0HEAP
0914102297NULL0HEAP
0930102354NULL0HEAP
0946102411NULL0HEAP
0962102468NULL0HEAP
0978102525NULL0HEAP
0994102582NULL0HEAP
01010102639NULL0HEAP
01026102696NULL0HEAP
01042102753NULL0HEAP
01058102810NULL0HEAP
01074102867NULL0HEAP
01090102924NULL0HEAP
01106102981NULL0HEAP
01138103095NULL0HEAP
01154103152NULL0HEAP
01170103209NULL0HEAP
01186103266NULL0HEAP
01202103323NULL0HEAP
01218103380NULL0HEAP
01234103437NULL0HEAP
01250103494NULL0HEAP
01266103551NULL0HEAP
01282103608NULL0HEAP
01314103722NULL0HEAP
01330103779NULL0HEAP
01474104292NULL0HEAP
01490104349NULL0HEAP
0101575400NULL0HEAP
0130099504NULL0HEAP
0146099561NULL0HEAP
01733581214NULL0HEAP
01749581271NULL0HEAP
01765581328NULL0HEAP
01781581385NULL0HEAP
01797581442NULL0HEAP
01813581499NULL0HEAP
01829581556NULL0HEAP
01845581613NULL0HEAP
01861581670NULL0HEAP
01877581727NULL0HEAP
01893581784NULL0HEAP
01909581841NULL0HEAP
01925581898NULL0HEAP
01941581955NULL0HEAP
01957582012NULL0HEAP
01989582126NULL0HEAP
0309576141NULL0HEAP
0373576369NULL0HEAP
0325576198NULL0HEAP
02021582240NULL0HEAP
02037582297NULL0HEAP
02057058364queue_clustered_index1CLUSTERED
02089058478PK__sysdiagrams__7D78A4E71CLUSTERED
02025058250queue_clustered_index1CLUSTERED
0341576255PK_employees1CLUSTERED
0354100302PK_activities_planned1CLUSTERED
0322100188PK_absences_planned1CLUSTERED
0290100074ci_commit_ts1CLUSTERED
0245575913PK_activities_weekly_copy_new1CLUSTERED
0274100017FSTSClusIdx1CLUSTERED
0277576027PK_activities_worked_schedule1CLUSTERED
01993058136queue_clustered_index1CLUSTERED
0149575571PK_absences_weekly_copy1CLUSTERED
0181575685PK_absences_worked_schedule1CLUSTERED
0213575799PK_activities1CLUSTERED
0117575457PK_absences1CLUSTERED
098clst1CLUSTERED
094cl1CLUSTERED
095cl1CLUSTERED
096clst1CLUSTERED
097clst1CLUSTERED
017cl1CLUSTERED
03clst1CLUSTERED
05clust1CLUSTERED
07clust1CLUSTERED
019cl1CLUSTERED
023cl1CLUSTERED
024clst1CLUSTERED
025clst1CLUSTERED
027clst1CLUSTERED
029clust1CLUSTERED
034clst1CLUSTERED
041clst1CLUSTERED
044clst1CLUSTERED
046cl1CLUSTERED
049clust1CLUSTERED
050clst1CLUSTERED
051clst1CLUSTERED
054clst1CLUSTERED
055clst1CLUSTERED
058clst1CLUSTERED
059clust1CLUSTERED
060clst1CLUSTERED
064clst1CLUSTERED
065clust1CLUSTERED
067clst1CLUSTERED
068clst1CLUSTERED
069clst1CLUSTERED
071clst1CLUSTERED
072cl1CLUSTERED
073cl1CLUSTERED
074clst1CLUSTERED
075clst1CLUSTERED
078cl1CLUSTERED
082clst1CLUSTERED
085clst1CLUSTERED
090clst1CLUSTERED
091cl1CLUSTERED
092cl1CLUSTERED
093cl1CLUSTERED
093nc12NONCLUSTERED
091nc12NONCLUSTERED
090nc12NONCLUSTERED
078nc2NONCLUSTERED
075nc12NONCLUSTERED
074nc12NONCLUSTERED
069nc12NONCLUSTERED
069nc23NONCLUSTERED
067nc12NONCLUSTERED
067nc23NONCLUSTERED
064nc2NONCLUSTERED
058nc12NONCLUSTERED
055nc12NONCLUSTERED
054nc2NONCLUSTERED
051nc2NONCLUSTERED
050nc12NONCLUSTERED
050nc23NONCLUSTERED
046nc12NONCLUSTERED
046nc23NONCLUSTERED
046nc34NONCLUSTERED
044nc2NONCLUSTERED
041nc2NONCLUSTERED
034nc12NONCLUSTERED
034nc23NONCLUSTERED
034nc34NONCLUSTERED
027nc12NONCLUSTERED
027nc23NONCLUSTERED
07nc2NONCLUSTERED
017nc2NONCLUSTERED
017nc23NONCLUSTERED
097nc12NONCLUSTERED
096nc12NONCLUSTERED
096nc23NONCLUSTERED
095nc12NONCLUSTERED
095nc33NONCLUSTERED
098nc12NONCLUSTERED
0213575799indact4NONCLUSTERED
0213575799indemp5NONCLUSTERED
01993058136queue_secondary_index2NONCLUSTERED
01490104349aaaaaNEWIRT_PK2NONCLUSTERED
0277576027indact4NONCLUSTERED
0277576027indemp5NONCLUSTERED
0274100017FSTSNCIdx2NONCLUSTERED
0290100074si_xdes_id2NONCLUSTERED
02025058250queue_secondary_index2NONCLUSTERED
0373576369icasidind11NONCLUSTERED
0373576369ifullnameind12NONCLUSTERED
0373576369itel1ind13NONCLUSTERED
0373576369itel2ind14NONCLUSTERED
0373576369visidind15NONCLUSTERED
0373576369siteind20NONCLUSTERED
02089058478UK_principal_name2NONCLUSTERED
02057058364queue_secondary_index2NONCLUSTERED
02037582297visidind23NONCLUSTERED
I'm seriously changing some of these to around the 90 mark (we update the tables daily) but I'm unsure of the impact on performance and space.
Can someone have a quick look (apologies for the fomatting) and advise please?
I'm assuming that adjusting the fill factor will reduce the amount of space needed for the index and data but I'd like confirmation before I do anything.