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?

0 Answers  

---

Once setting replication, can you have distributor on sql server 2005, publisher of sql server 2008?

0 Answers  

---

What are explicit and implicit transactions?

4 Answers   BirlaSoft,

---

what is differece between union and union all

6 Answers  

---

What do you understand by the data quality services in sql server?

0 Answers  

---

What is the use of sql profiler in sql server 2012?

0 Answers  

---

Explain Normalization and DE normalization

0 Answers   iNautix,

---

Explain the microsoft sql server delete command? : SQL Server Architecture

0 Answers  

---

What are the steps you will take to improve performance of a poor performing query?

1 Answers  

---

how to find the second salary?

10 Answers   HCL, Prithvi,

---

What is star, snowflake and star flake schema? : sql server analysis services, ssas

0 Answers  

---

After creating the cube, if we added a new column to the oltp table then how you add this new attribute to the cube? : sql server analysis services, ssas

0 Answers  

---