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 are the differences between decimal and float in ms sql server?

0 Answers  

---

Difference between Cluster and Non-cluster index?

32 Answers   Accenture, Agility e-Services, eClinicalWorks, HCL, Infosys, Oracle, Satyam, Yardi,

---

What is an extended Stored Procedure?

1 Answers  

---

What is the significance of master, tempdb and model databases?

0 Answers  

---

How you trouble shoot when any job fails

0 Answers  

---

What are xml indexes?

0 Answers  

---

What is a trigger?

4 Answers  

---

What is sql profiler. What are the default templates with it? : sql server database administration

0 Answers  

---

What are the all different types of Joins in SQL Server 2000, Anybody can explain each join with definition..Thanks in advance....

9 Answers   DELL, i Tech, Infosys, Siemens, TCS,

---

What are trace flags?

0 Answers  

---

What is a print index?

0 Answers  

---

What is difference between clustered index and non clustered index?

0 Answers  

---