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 do you mean by table and field in sql?

0 Answers  

---

How to send email from database?

0 Answers  

---

What is multi-statement table-value user-defined function?

0 Answers  

---

What happens if the update subquery returns multiple rows in ms sql server?

0 Answers  

---

How do I start sql server 2016?

0 Answers  

---

---

What is a mutating table error and how can you get around it?

0 Answers  

---

What is dynamic cursor in SQL SERVER?

0 Answers  

---

What are the advantages of using stored procedures in sql server?

0 Answers  

---

How do I edit a procedure in sql server?

0 Answers  

---

Explain what is the difference between a local and a global temporary table?

0 Answers  

---

Can sql servers link to other servers?

0 Answers  

---

How to Generate a Series of Random Integers With T-SQL?

1 Answers  

---