Page – The fundamental unit of data storage in SQL Server
DBCC PAGE – allows you to examine the contents of data and index pages.
DBCC IND – lists of all database pages that make up the selected index or partition.
Data Page – stores data,except text, ntext, image, nvarchar(max), varchar(max), varbinary(max), and xml data, when text in row is set to ON.
Log Files – a series of log records.
Extents – a collection of eight physically contiguous pages and are used to efficiently manage the pages.
.mdf – Primary data file.
.ndf – Secondary data file.