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.

What is a trace frag? Where do we use it?

0 Answers  

---

What does sql server mean?

0 Answers  

---

When do you use SQL Profiler?

3 Answers   Wipro,

---

How to reaname table name without using sp_Rename in sql server..?

0 Answers   Wipro,

---

Explain the different index configurations a table can have?

0 Answers  

---

---

Explain different types of lock modes in sql server 2000?

0 Answers  

---

What are the approximate numeric data types?

0 Answers  

---

Mention the differences between substr and charindex in sql server.

0 Answers  

---

Describe the left outer join & right outer join. : sql server database administration

0 Answers  

---

How to select some specific columns from a table in a query in ms sql server?

0 Answers  

---

Explain cdc and sql injection?

0 Answers  

---

Is the primary key column of a table an index in ms sql server?

0 Answers  

---