Answer / rajesh kumar

An index is used to quickly locate the data record from
which the required data is read. In other words, the index
is only used to locate data records in the table and not to
return data.

A covering index is a special case where the index itself
contains the required data field and can return the data.

Answer / midhu

- Index covering means that "Data can be found only using indexes, without touching the tables"

Answer / saikat mukherjee

The observed improvement is due to the fact that the
nonclustered index contained all of the required information
to resolve the query. No Key Lookups were required. An index
that contains all information required to resolve the query
is known as a "Covering Index"; it completely covers the query.

Why use “pivot” in sql server?

0 Answers  

---

What is the importance of three tier architecture?

0 Answers   QuestPond,

---

where can you add custom error messages to sql server? : Sql server administration

0 Answers  

---

How can we determine what objects a user-defined function depends upon?

0 Answers  

---

When we should use and scope of @@identity?

0 Answers  

---

What is the command used to check locks in microsoft sql server?

0 Answers  

---

You have a stored procedure, which execute a lengthy batch job. This stored procedure is called from a trigger you do not want to slow the data entry process you do not want trigger to wait for this batch job to finish before it completes itself what you can do to speed up the process?

0 Answers  

---

What authentication modes does sql server support?

0 Answers  

---

what are file groups?

3 Answers   Evalueserve,

---

Give main differences between "Truncate" and "Delete".

0 Answers   HCL,

---

what is a traditional network library for sql servers? : Sql server database administration

0 Answers  

---

Difference between Inner vs outer joins?

0 Answers  

---