I got a question:
If a data page is split, there is a pointer added to the original page to point toward the new page (forward pointer like you just explained). If this new page is split again, is there another Forward pointer added to this page? This would mean that we are now at left with 3 pages?
Is there a way to set SQL to automatically removed this forward pointer? In a job maybe?
BTW good short and simple article.
Always looking for a challenge