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.

Mention the differences between local and global temporary tables.

0 Answers  

---

how insert selected column only ?

3 Answers   Robert Half,

---

Do you know how to send email from database?

0 Answers  

---

What is the cartesian product of table?

0 Answers  

---

hi, may i know what is the command to get abstract the current month, current year and current day from a given date.i want these three in a isolated way..seperatedly is that any way in sql server 2000

3 Answers  

---

Can a stored procedure call another stored procedure. If yes what level and can it be controlled?

2 Answers  

---

Can binary strings be used in arithmetical operations?

0 Answers  

---

Write a SQL query to delete a table?

0 Answers   Amdocs,

---

Is null in sql server?

0 Answers  

---

How do you use DBCC statements to monitor various aspects of a SQL server installation?

1 Answers  

---

How do I create a partition table in sql server?

0 Answers  

---

syntax for deleting the database in T SQL

5 Answers  

---