What are pages and Extents?

What are pages and Extents?

A page is a unit of data storage in SQL. The size of a page is 8Kb. A page has a header and a body. Different types of pages are: Date, text, index , page free space etc. The data rows are put on the page serially after the header.

Extents are units in which space is allocated to tables and indexes. An extent is 8 continuous pages. SQL Server has two types of extents: uniform and mixed extent. For efficient allocation, the SQL server does not allocate whole extents to tables with small amounts of data
What are constraints in SQL Server?
Constraints enforce the data integrity to the database and protect columns of the table from unwanted values......
Different ways of moving data/databases between servers and databases
There are several ways of doing this. One can use any of the following options: - BACKUP/RESTORE, Dettaching/attaching databases,.......
How DTS is used to extract, transform and consolidate data
Data Transformation Services is a set of tools available in SQL server that helps to extract, transform and consolidate data.......
Post your comment