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)

How to find index size for each index on table?

0 Answers  

---

What are the Advantages of using CTE in sql server?

0 Answers   Winsol Solutions,

---

What are the different editions available in sql server 2000?

0 Answers  

---

What is difference between joins and subqueries?

0 Answers  

---

what is sql injection?

2 Answers  

---

how to implement locking in sql server

3 Answers   Satyam,

---

Is it possible for a stored procedure to call itself or recursive stored procedure?

0 Answers  

---

HOW TO RENAME A COLUMN NAME

3 Answers  

---

If you are given access to a SQL Server, how do you find if the SQL Instance is a named instance or a default instance?

0 Answers  

---

What are “lost updates”?

0 Answers  

---

What is a view and what are its advantages?

0 Answers  

---

What is change data capture (cdc) in sql server 2008?

0 Answers  

---