Categories
Sql Server

How Data is stored in Sql server

Data in sql server is stored in Data pages.Pages in a SQL Server data file are numbered sequentially, starting with zero  for  first page in data file. Each file in a database has a unique file ID number. To uniquely identify a page in a database, both the file ID and the page number are required. […]