SQL Advanced #6: Pages and Extents

preview_player
Показать описание
This time we wrap our heads around (data) pages and extents.
The video is basically a part 1 since the main goal is to describe how SQL Server is organizing data pages and storing data in general.

Next video in this series will be about IAM pages, GAM and SGAM
Рекомендации по теме
Комментарии
Автор

I'm not quite sure I understand the last part, let's say we have 10 pages which belong to one table is it correct to assume that the first 8 are stored in a uniform extent and the next two are stored again in a mixed extent or are the next two pages also stored in a uniform extent with 6 open spaces for more pages?

michiel