Answer / madhuri

Sql server architecture

Database having physical and logical databases
in physical databases contains filegroup and Transcation log
in filegroup consists of datafile--36,767 TB
datafile consists of table--a single table can have 1024
columns.
Table consists of extents---8 contigious pages 1 extent--
64KB
exetents consists of pages---8KB
pages consists of rows---8060 bytes(max row size)
Tnasaction log is userdefind filegroup by default it's
primary file group.
Logical --- database objects like
views,sp,functions,triggers,indexes and roles etc.
------authentication modes
There are two types of Authentication modes.
1.Windows Authentication Mode.
2.Sql server Authentication(mixed mode)

What's the difference between a primary key and a unique key?

10 Answers   Wipro,

---

How To Change Column Ordinal Position in SQL Server 2005 using Query i.e I Want To Add Column at Particular Ordinal Position in SQL Server 2005

2 Answers  

---

Where in ms sql server is ’100’ equal to ‘0’?

1 Answers  

---

Define candidate key, alternate key, composite key.

13 Answers   Infosys, Software India,

---

What is the diff between Static Queries and Dynamic queries give me some examples

2 Answers   CSC,

---

What is fill factor and pad index?

1 Answers  

---

what are constraints? : Sql server database administration

1 Answers  

---

Why variables called the most powerful component of ssis?

1 Answers  

---

What about UPDATESTATISTICS ?

2 Answers   HCL, Intelligroup,

---

what is bit data type? and what are the information that can be stored inside a bit column?

2 Answers  

---

Explain where clause?

1 Answers  

---

please differentiate between delete and truncate?

1 Answers  

---