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 to create prepared statements using odbc_prepare()?

1036

---

Insert syudents details in table.Current system date &time insert into joining time.How do insert?( in sysdate only return current system date how do add time?)

1840

---

What is the difference between Normalization and De-normalization?

1070

---

Explain optimistic and pessimistic concurrency?

972

---

How to resolve the orphan use problem? : sql server security

996

---

How is a full-text index updated?

930

---

You have developed an application which uses many stored procedures and triggers to update various tables users ocassionally get locking problems which tool is best suited to help you diagnose the problem?

986

---

What is the contrast between sql and mysql?

1084

---

What is the sql profiler?

927

---

How do you migrate data from mssql server to azure?

165

---

What is awe?

985

---

Are there issues when exporting SSRS reports into Microsoft Excel? When my users are trying to export a SSRS report into Microsoft Excel, one or two columns in the report appear to merge together. Why might this be?

188

---

How to delete an existing database user?

1000

---

How do you rename a table in sql server?

1001

---

What is RAID? What are the different types of RAID configurations?

1103

---