Answer Posted / shaurabh thapa

Cluster Index is faster because it has data in the leaf
nodes along with the key. Non cluster on the other hand uses
cluster index key to search the data and therefore
relatively less fast.

Explain what is “asynchronous” communication in sql server service broker?

961

---

What are ddl triggers and types of ddl trigger?

1097

---

How can we check the sql server version?

1128

---

Can you please explain the difference between function and stored procedure?

1048

---

What is the tcp/ip port on which sql server runs?

1244

---

Is it possible in sql table to have more than one foreign key?

1094

---

How to rename databases in ms sql server?

1260

---

Explain powershell included in sql server 2008?

1117

---

How to list all columns in a table using odbc_columns()?

1034

---

How to count duplicated values in a column in ms sql server?

1171

---

When you use @@error and try-catch?

1097

---

What are scheduled tasks in sql server?

1148

---

What are acid properties of transaction?

997

---

How can a user-defined datatype be created?

1038

---

What happens when converting big values to integers?

1059

---