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 steps to take to improve performance of a poor performing query? : sql server database administration

0 Answers  

---

What is snapshot replication?

0 Answers  

---

List the data types available in mssql?

0 Answers  

---

Why olap is used?

0 Answers  

---

What is unique key constraint?

0 Answers  

---

What is temporary table in sql server? Why we use temp table?

0 Answers  

---

Mention the differences between local and global temporary tables.

0 Answers  

---

What are trace flags and mention a few common trace flags used with sql server?

0 Answers  

---

How can windows applications connect to sql servers via odbc?

0 Answers  

---

What's the purpose of Stored Procedure?

6 Answers   Wipro,

---

Do you know the different ddl commands in sql?

0 Answers  

---

Explain a differential backup?

0 Answers  

---