Answer Posted / kshirsagar sambhaji

The difference is that, Clustered index is unique for any
given table and we can have only one clustered index on a
table. The leaf level of a clustered index is the actual
data and the data is resorted in case of clustered index.
Whereas in case of non-clustered index the leaf level is
actually a pointer to the data in rows so we can have as
many non-clustered indexes as we can on the db.

What is a field in a table?

983

---

What is attribute relationships, why we need it? : sql server analysis services, ssas

908

---

What is sql server agent and what are the two modes of authentication in sql server?

992

---

How to receive returning result from a query?

1034

---

Explain “row_number()” in sql server with an example?

947

---

how do you determine the Load performance of any query in sql server {example how do u determine performance of a select stmnt which returns Dynamically many no of records ... some times 100,1000,10000 etc., }

2261

---

What is a hint?

934

---

How to store and query spatial data?

935

---

Explain what is the main purpose of having conversation group?

879

---

Can you change the data type of a column in a table after the table has been created? If so, which command would you use?

976

---

What is difference between clustered index and non clustered index?

1027

---

What are types of subqueries?

995

---

Explain identity in sql server?

951

---

Which table keeps information about stored procedures?

890

---

Tell me what is use of except clause? How it differs from not in clause?

898

---