Answer Posted / govind

its used to create auto indexes on table. means non
clustred indexes are created on table.which is used to
easily craeted data pages for modification and deleteion.

What is a user-defined function in the sql server and what is its advantage?

1108

---

What is the index requirement in SQL Azure?

98

---

How can you hide the sql server instances?

1024

---

What are the 7 disadvantages to a manual system?

987

---

How to get nth highest salary from employee table.

1165

---

How is table type constraint applied to a table?

981

---

Is sql server is free?

985

---

What is nested transaction?

1106

---

Mention the differences between substr and charindex in sql server.

1058

---

What is a derived table?

935

---

Can I work with several databases simultaneously? : sql server management studio

997

---

Suppose you want to implement the following relationships while designing tables. How would you do it?a.) One-to-oneb.) One-to-manyc.) Many-to-many

944

---

How to add a new dsn with the odbc driver for sql server?

1063

---

How to find the source of a table in sql server?

1000

---

How to query multiple tables jointly?

995

---