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.

Why do we partition data?

1079

---

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

1053

---

what is dbcc? : Sql server database administration

1077

---

What is the default schema of your login session in ms sql server?

1092

---

Explain the properties of subqueries in sql server?

1137

---

How can you list all the columns in a database?

970

---

Explain the concept of view and Types of views in SQL server?

1034

---

How network traffic be reduced by using the stored procedure?

1169

---

What is collation?

1192

---

What is serializable?

1086

---

Does full backup break log chain?

1013

---

Explain triggers?

1061

---

How do you drop an index?

973

---

How to insert stored procedure result into temporary table?

1064

---

How does a profiler work?

993

---