When I was at a SQLSaturday a few months ago, I attended a session that hit upon SQL Server Internals, one of my favorite topics.  During the session the presenter was talking about page allocation, and mentioned that pages for a table and its indexes will reside in the same extents.  Now, I remember immediately…