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.

What is ms sql server reporting services?

1036

---

What is 'write-ahead log' in sql server 2000 ?

1034

---

Define the one-to-one relationship while designing tables.

888

---

can you implement data mining in SSRS?

146

---

You want to implement the many-to-many relationship while designing tables. How would you do it?

982

---

Is port 1433 secure?

977

---

What is scalar user-defined function?

1077

---

Explain differentiate between a having clause and a where clause?

891

---

Can you pass expressions to stored procedure parameters?

1012

---

How do I get Report Builder to generate a parameter that can be set by users viewing the report?

146

---

How to create a view with data from multiple tables?

999

---

Explain security with sql azure?

186

---

What are the difference between primary key and unique key? : sql server database administration

925

---

If no size is defined while creating the database, what size will the database have?

970

---

Do you know what is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure?

985

---