SQL Server has the concept of fill factor for leaving extra space in pages to reduce the number of page splits. If you picture library shelves, it’s like leaving space for a couple new books on each shelf. It’s a trade-off though, putting in that space may reduce page splits but it increases the number […]

Read more "Use 100% Fill Factor on Insert Only Tables"