Best Practices Best Practice No.9 June 3, 2013 Sarabpreet Singh Anand Provide appropriate Fill Factor while creating\rebuilding Indexes to avoid\minimize fragmentation.