What is Extent and types of Extent?

What is Extent and types of Extent?

It is the basic unit in which space is managed.

- An extent is eight physically contiguous pages. It means that SQL Server database has 16 extents per megabyte.

Extents are classified into two types:

1. Uniform extent
2. Mixed extent

- SQL Server does not allocate whole extents to the tables because to make its space allocation efficient.

1. Uniform extent:

- It is owned by a single object.
- All the eight pages in the extent can only be used by the owning object.

2. Mixed extent:

- It is shared by up to eight objects.
- Each of the eight pages in the extent can be owned by a different object.
- A new table or index is generally allocated pages from mixed extents.
What is the use of DBCC commands?
DBCC is database consistency checker. DBCC commands are used to check the consistency of the databases........
Define COLLATION
Collation is the order that SQL Server uses for sorting or comparing textual data........
Where is users names and passwords stored in SQL Server?
They are stored in master db in the sysxlogins table.......
Post your comment