SQL Server Architecture Question:
Please illustrate physical database architecture?
Answer:
The physical database architecture describes how the database and files are organized in a SQL server.
Pages and extents: these describe how the data is stored
Physical Database Files and File groups :- describes the operating system files used to store data and logs.
Space Allocation and Reuse :- Describes the algorithms used for space allocation.
Table and Index Architecture :- Describes the way pages for tables can be indexed
Pages and extents: these describe how the data is stored
Physical Database Files and File groups :- describes the operating system files used to store data and logs.
Space Allocation and Reuse :- Describes the algorithms used for space allocation.
Table and Index Architecture :- Describes the way pages for tables can be indexed
| Previous Question | Next Question |
| Do you know what are pages and Extents? | What is the difference between CUBE operator and ROLLUP operator? |