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 properties of sub-query?

0 Answers  

---

How To Change Column Ordinal Position in SQL Server 2005 using Query i.e I Want To Add Column at Particular Ordinal Position in SQL Server 2005

2 Answers  

---

What does dml stand for?

0 Answers  

---

What is impersonation? What are the different impersonation options available in ssas? : sql server analysis services, ssas

0 Answers  

---

What is the downside of using udf?

0 Answers  

---

Why we need to use secondry database file? though, we can do same work using primary database file also.

2 Answers   Microsoft,

---

What is blocking in SQL Server? If this situation occurs how to troubleshoot this issue

2 Answers   IBM,

---

What are the approximate numeric data types?

0 Answers  

---

How do I create a stored procedure in sql server?

0 Answers  

---

Is it possible to create trigger on views?

0 Answers  

---

Does a full backup include transaction log?

0 Answers  

---

What functions can a view be used to performed?

0 Answers  

---