Answer Posted / abhijit

A clustered index sorts and stores the data rows in the
table based on the index key values. Therefore only one
clustered index can be created on each table because the
data rows themselves can only be sorted in one order.

What is logshipping and its purpose?

1064

---

Differentiate between truncate vs delete in mssql?

1160

---

What happens if null values are involved in comparison operations?

1039

---

Which joins are sql server default?

1067

---

How to maintain a fill factor in existing indexes?

1049

---

Tell me what is log shipping?

1029

---

How to get the definition of a stored procedure back?

1018

---

Can we write ddl in trigger?

966

---

List out some of the requirements to set up a sql server failover cluster?

1074

---

what are isolation levels? : Sql server database administration

1058

---

How can I tell if sql server is 32 or 64 bit?

1010

---

What does it mean to normalize a database and why would you do it?

1022

---

what is the difference between them (ethernet networks and token ring networks)? : Sql server database administration

1098

---

Do you know what are the ways available in sql server to execute sql statements?

1082

---

Explain iaas, paas and saas?

92

---