When there is not enough room on a page for a new row, a Server splits the page, allocates a new page, and moves some rows to the new page.
SQL Server architecture - Describe in brief database architecture.
Answer
Database architecture describes the design of the database. It explains how the data is stored. The data of the server is stored in databases. This database is further split into one or more discs. The database can be considered to have two layers. Physical layer, which is a transparent layer for the database administrators to work on. Other users typically work on the user view layer. Tables, views, procedures forms this view.
No comments:
Post a Comment