Ssis rowcount variable not updating
Regardless of how the page splits, the new page is almost never anywhere near the other pages of the index it goes with.
The scattering of index pages means that the disk heads have to move around a lot more leading to poor performance.
Working in a technical field has it’s ups and downs.
I have to give special thanks to Brent Ozar (Blog|Twitter) for taking the time to review and offer his thoughts on the query.By now it should be clear that choosing the right fill factor for your indexes is one of the more important steps in creating an index, right behind picking the right key columns.The problem is knowing how to pick a good number and here is where it gets tough because like everything else: It Depends and It Changes.I still have a long way to go before I can suggest a sure-fire approach to curtailing this behavior.Quite honestly, I have been known to fall back on “fancy tech words” on more than one occasion to hide ignorance or to try to seem smart (OK that was hiding ignorance twice but it sounds better the way I said it).
Most page splits involve taking half the rows on the page and putting them onto a newly allocated page somewhere else on your data file, allowing sufficient room for the new row to be added to either page.