Answer Posted / arunyadav007

Clustered Index.
Because the leaf level of a clustered index is the actual
data and the data is resorted in case of clustered index.
In case of non-clustered index the leaf level is actually a
pointer to the data in rows. The data is stored in one
place, the index in another, with pointers to the storage
location of the data. The items in the index are stored in
the order of the index key values, but the information in
the table is stored in a different order.

Thanks,

Arun

Define outer join?

1044

---

Explain the collation?

1146

---

Define msdb database?

1075

---

Explain powershell included in sql server 2008?

1112

---

How do you check sql server is up and running?

1044

---

What is the difference between online clustering and Offline clustering?

2472

---

Explain the stored procedure?

1094

---

Explain about Views?

1120

---

you want to be sure that queries in a database always execute at the maximum possible speed. To achieve this goal you have created various indexes on tables which other statement will keep the database in good condition? : Sql server administration

1154

---

What happens to a statement batch if there is a compilation error?

1009

---

What is sharding?

116

---

What is bcnf normalization form?

1158

---

What is snapshot replication?

1096

---

Do you know spatial data types - geometry and geography in sql server 2008?

1085

---

What is the recovery model? List the types of recovery model available in sql server?

944

---