
Index fragmentation via page splits
In this blog post we are going to cover the logical fragmentation caused by page splits in SQL Server. You will also discover the performance hit taken when the next logical page is not the next physical page as well as the footprint generated in the transaction log when a page split occurs. We will…
Follow My Blog
Get new content delivered directly to your inbox.