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.

How fixed length strings are truncated and padded?

965

---

What are the different types of stored procedures?

1099

---

How to drop an existing user defined function in ms sql server?

1016

---

Can a trigger be created on a view?

936

---

How can I get data from a database on another server?

971

---

What is the difference between stored procedure and user defined functions?

1174

---

Which tcp/ip port does the sql server run on? How can it be changed?

1034

---

What is 'Join' and explain its various types.

1117

---

What are the types of sql server?

1034

---

Does a full backup include transaction log?

949

---

What do you understand by recursive stored procedures?

972

---

what's sql server? : Sql server database administration

979

---

What is "scheduled jobs" or "scheduled tasks"?

958

---

What is the difference between grant and with grant while giving permissions to the user?

941

---

What stored by the model? : sql server database administration

935

---