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.

In which tcp/ip port does sql server run? Can it be changed?

0 Answers  

---

Alternative way to DetDate() function?

5 Answers  

---

What is nolock hint in sql server 2008

0 Answers   HCL,

---

Explain different types of collation sensitivity?

0 Answers  

---

Explain the third normal form(3nf)?

0 Answers  

---

What is the difference between count and distinct count?

0 Answers  

---

What command is used to delete a table from the database in the sql server and how?

0 Answers  

---

Explain use of expression builder.

0 Answers  

---

What is update locks?

0 Answers  

---

Explain few examples of stored procedure over triggers?

0 Answers   ADITI,

---

What samples and sample databases are provided by microsoft?

0 Answers  

---

What is a cube? : sql server analysis services, ssas

0 Answers  

---