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.

What does <> symbol mean?

0 Answers  

---

How to retrieve field values using mssql_result()?

0 Answers  

---

Can you pass expressions to stored procedure parameters?

0 Answers  

---

How To delete duplicate record from a particular table?

12 Answers   eXensys, Foxfire,

---

What is sqlservr.exe - process - sql server (sqlex?press)?

0 Answers  

---

What is ddl command?

0 Answers  

---

What are the different types of cursor?

0 Answers   HCL,

---

Can group by be used without aggregate functions?

0 Answers  

---

What is ms sql server service broker?

0 Answers  

---

What is table valued function and scalar valued functions?

0 Answers  

---

How will you monitor replication activity and performance? What privilege do you need to use replication monitor? : sql server replication

0 Answers  

---

What is the difference between join and inner join?

0 Answers  

---