Answer / 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

Explain log shipping?

0 Answers  

---

How to include date and time values in sql statements?

0 Answers  

---

Define outer join in sql server joins?

0 Answers  

---

how to insert the values in 5 table at a time with triggers . if u have any solution then co-operate me ?

1 Answers  

---

How can u get the number of pupils connecting the database?

1 Answers   Cap Gemini,

---

How to view the error log for any specific instance? : sql server database administration

0 Answers  

---

Explain about merge replications?

0 Answers  

---

How to generate create table script on an existing table in ms sql server?

0 Answers  

---

Please get the 4 th maximum salary from a table without using any sql keyword (TOP,MAX are mot allowed)

8 Answers  

---

Can a rule be bound to any column of any data type?

0 Answers  

---

What is spatial and temporal data?

0 Answers  

---

Explain syntax for dropping triggers?

0 Answers  

---