Answer Posted / naren

clustered index is created on actual data.

Non clustered index ix created on pointer of data.

If there is primary key by default clustered index is
created.
else non clustered index created.

only one clustered index is possible to create.


249 non clustered indexex can be created.

List types of tables in SQL Azure?

126

---

why does a sql statement work correctly outside of a user-defined function, but incorrectly inside it? : Sql server administration

976

---

Explain different types of locks in sql server.

1009

---

What is enhanced database mirroring in sql server 2008?

913

---

Explain the various types of concurrency problem?

1135

---

Is it true that rules do not apply to data already existing in a database at the time the rule is created?

988

---

How to drop existing indexes in ms sql server?

1013

---

Explain what is meant by replication of database?

956

---

What is a data collection table?

943

---

How to connect of datebase with sql express.?

1049

---

What does man by sql wildcard characters in sql server?

994

---

What is dbcc command in sql server?

1019

---

Data table as parameter in sql server?

973

---

Does any body please help me what question's have asked for SSRS in the interview?

2086

---

Why do you want to join software field as you have done your BE in Electronics?

2103

---