1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

How the data stores in a page?

Question Posted / guest


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

Post New Answer

More SQL Server Interview Questions

How to write a query with a left outer join in ms sql server?

0 Answers  

What is the maximum rows in sql server table?

0 Answers  

how to copy sysdatabase file from c: Drive to D: Drive in SQL Server.

6 Answers   IBM,

What happens if you insert a duplicate key for the primary key column in ms sql server?

0 Answers  

How to add an address record into adventureworkslt?

0 Answers  




Other than truncate statement, which other command can by-pass the trigger on the tables?

0 Answers  

Explain active/passive and active/active cluster configurations?

0 Answers  

What is the default value of CHAR type?

10 Answers   Bosch,

Hi all, I need query help for below senorio, could you please help me. TableName = City CITYID ContinuationID CITYNAME 1 1 SAN 1 2 DIEGO 2 1 SAN 2 2 FRANCISCO 3 1 CHICAGO 4 1 NEW 4 2 YORK 4 3 CITY Could you please help me to write a generalized SQL that returns results as given below in the Query result CITYID NAME1 NAME2 NAME3 NAME4 NAME5 1 SAN DIEGO 2 SAN FRANCISCO 3 CHICAGO 4 NEW YORK CITY

5 Answers   TCS,

How to execute a stored procedure in ms sql server?

0 Answers  

What is 'Join' and explain its various types.

0 Answers   Genpact,

What is a heap?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories