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.
Quick Answer
SQL Server stores data in 8KB pages. Data pages hold actual table rows. Index pages hold B-tree index entries at each level — leaf pages point to actual data rows (or contain them for clustered indexes). Each page belongs to one object and is managed by the buffer pool for caching.
S
SugharaIQ Editorial Team
Verified Answer
This answer has been peer-reviewed by industry experts holding senior engineering roles to ensure technical accuracy and relevance for modern interview standards.
Want to bookmark, take notes, or join discussions?
Sign in to access all features and personalize your learning experience.
Source: SugharaIQ