Answer
SQL Server stores all data in 8 KB pages.
- Data pages store full table rows.
- Index pages store B-tree navigation structures and pointers.
Understanding pages explains index fragmentation, logical reads, and physical I/O behavior.
Want to bookmark, take notes, or join discussions?
Sign in to access all features and personalize your learning experience.
Source: SugharaIQ