Answer Posted / arunyadav007
The fundamental unit of data storage in SQL Server in the
page. The disk space allocated to a data file (.mdf
or, .ndf) in a database is logically divided into pages
numbered form “0” to ‘n’. Disk I/O operation are performed
at page level.
In SQL server, the page is 8 kb. This means SQL Server
database have 128 pages per MB. Each page begins with a 96
byte header. That is used to store system information about
the page.
Page types used in the data files of the SQL Server
database.
1.) Data
2.) Index
3.) Text image
4.) Global allocation map, shared global allocation map
5.) Page free space.
6.) Index allocation map
7.) Bulk changed map
8.) Differential changed map
** Maximum amount of data and overload that is contained in
single row on a page is 8060 bytes ()8Kb.
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
What is resource governor?
What is the beast way to write CTE in SQL Server ?
How do I start and stop sql server?
What is the purpose of floor function?
How do you rename a table in sql server?
How do I create a partition table in sql server?
Why is normalisation important?
What are the advantages of having an index on the sql server?
Which are new data types introduced in sql server 2008?
How many types of objects are there?
What is auditing in sql server?
Explain the difference between functions and stored procedures in sql server?
How to enter binary string literals in ms sql server?
Where is trigger in sql server?
Can two different columns be merged into single column? Show practically?
