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)

Which command is used for user defined error messages?

0 Answers  

---

Is it possible to call a stored procedure within a stored procedure?

0 Answers  

---

What triggers long term care?

0 Answers  

---

What is the purpose of the model database?

0 Answers  

---

What is instead of trigger sql server?

0 Answers  

---

---

Explain what is the difference between union and union all?

0 Answers  

---

What is the datatype of rowid?

0 Answers  

---

What is a raid and what are different types of raid configurations?

0 Answers  

---

What according to you is the difference between mysql and sql server performance?

0 Answers  

---

What is the diffrence between update_one and auto_fix?

3 Answers   IBM,

---

what is syntex second or third highest salary. thanks & Regards Dhirendra sinha

7 Answers  

---

Can you get second highest salary from the table?

0 Answers   QuestPond,

---