How the data stores in a page?
Answer / 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 |
What are the two authentication modes in sql server?
explain query execution plan
How does normalization work?
What is database replicaion? What are the different types of replication you can set up in SQL Server?
Explain how to send email from sql database?
What do you understand by the analysis services in sql server?
What does it mean if @@cursor_row returns a negative number?
What is the difference between a Local temporary table and a Global temporary table? How is each one used?
What is deadlock and how to avoid the deadlocks.
What is the primary use of the model database?
explain what is a schema in sql server 2005? Explain how to create a new schema in a database? : Sql server database administration
Why is normalisation important?