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.

How to get a list of table columns using the "sp_columns" stored procedure in ms sql server?

961

---

Can you use order by when defining a view?

917

---

Will sql server 2005 allow you to reduce the size of a column?

920

---

what are the types of indexes? : Sql server database administration

1062

---

What are the differences between triggers and stored procedures?

992

---

What is use of attribute hierarchy optimized state? : sql server analysis services, ssas

1010

---

What are date and time data types in ms sql server?

1021

---

Explain in details security in SQL azure?

121

---

How can i Relate Tables in SSIS

1036

---

What are the advantages of partitioning?

1046

---

What are different types of join?

1237

---

Explain acid?

1018

---

As per your opinion what are the five top responsibilities of a dba? : sql server database administration

1064

---

What command would you use to create an index?

984

---

Explain the collation?

1047

---