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)

How can windows applications connect to sql servers via odbc?

1128

---

How to make conditional sum in ssrs?

177

---

How to execute a sql statement using mssql_query()?

1051

---

What is identity?

1014

---

What is a scheduled job or what is a scheduled task?

952

---

What are scalar functions?

1000

---

Explain the steps to use transact-sql cursor?

1063

---

What are the differences between char and nchar in ms sql server?

1087

---

Which joins are sql server default?

1011

---

Difference between Sql server reporting services and Crystal reports?

168

---

How to convert a numeric expression from one data type to another?

1016

---

Write a SQL command to insert and update only a particular field?

1110

---

What are the advantages of sql azure?

140

---

what is new philosophy for database devises for sql server 7.0? : Sql server database administration

1009

---

Explain about analysis services?

1049

---