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 an index in sql?
What is the difference between insensitive and scroll cursor?
What is the definition for sql server 2000?
Where sql server usernames and passwords are stored in a sql server?
How do I schedule a sql server profiler trace?
what method you can use to reduce the overhead of Reporting Services data sources?
What is table level trigger?
What is the difference between executequery () and executeupdate ()?
what is a schema in sql server 2005? Explain how to create a new schema in a database? : Sql server database administration
Which joins are sql server default?
What is subquery in sql?
What do you mean by SQL injection attack?
what is the difference between openrowset and openquery?
Can you please explain the difference between function and stored procedure?
explain different levels of normalization? : Sql server database administration
