Answer Posted / 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)

Does sql server 2000 clustering support load balancing?

954

---

What is difference between rownum and rowid?

892

---

what is create database syntax? : Sql server database administration

1093

---

What is the difference between clustered index and primary key?

907

---

Difference between report and query parameter.

1081

---

How do I setup a sql server database?

1063

---

What is scd (slowly changing dimension)? : sql server analysis services, ssas

1000

---

What are the requirements to use odbc connections in php scripts?

1104

---

How many types of the database links?

1062

---

What is implicit cursors?

1073

---

you notice that the transaction log on one of your databases is over 4gb the size of the data file is 2mb what could cause this situation, and how can you fix it? : Sql server administration

965

---

What are transactions and its controls?

1051

---

Do you know what is blocking?

943

---

What is used to replicate sessions between instances in coldfusion clusters?

1061

---

what is the information that can be stored inside a bit column? : Sql server database administration

949

---