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.

Explain about Normalization?

0 Answers   Infosys,

---

What is the default server name for sql server?

0 Answers  

---

What are the different methods available under sqlcommand class to access the data?

0 Answers   UGC Corporation,

---

What is the difference between writing data to mirrored drives versus raid5 drives

0 Answers  

---

What are xml indexes?

0 Answers  

---

What do you understand by the denormalisation?

0 Answers  

---

How do you trace the traffic hitting a sql server?

0 Answers  

---

Explain what is raid and what are different types of raid levels?

0 Answers  

---

How do you troubleshoot errors in a SQL Server Agent Job?

0 Answers  

---

What is compound operators?

0 Answers  

---

What is a raid and what are different types of raid configurations?

0 Answers  

---

How real and float literal values are rounded?

0 Answers  

---