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.

1. SELECT SUM(sal) as “Gross Salary” from EMPLOYEES; 2. SELECT MAX(sal) as “Highest Salary” from EMPLOYEES; ouput should be in table format

2 Answers  

---

1)what is the difference between Reinitializing a Subscription and synchronization the subscription? 2)when to use reinitializing ? 3)when to use synchronization? 4)when adding table or deleting a table what to do?(reinz.. or syn) 5)when adding a column what to do?

0 Answers  

---

difference between select column name from table name where serviceid=2; and select max(column name) from table name where serviceid=2; IN ORACLE

3 Answers   Intel, Wipro,

---

How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database?

0 Answers  

---

Can a table have 2 primary keys?

0 Answers  

---

What is merge statement?

0 Answers  

---

What is the meaning of sql server?

0 Answers  

---

What is the use of sign function?

0 Answers  

---

What are different types of database indexes?

0 Answers  

---

whate is advantages of sql server 2000

0 Answers  

---

What are transactions and its controls?

0 Answers  

---

What Is The Difference Between Primary Key & Super Key

3 Answers   Accenture,

---