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.

Explain about remote stored procedure?

0 Answers  

---

Explain some DBCC commands?

6 Answers  

---

What are pages and extents? : SQL Server Architecture

0 Answers  

---

How to remove duplicate rows from table?

0 Answers  

---

Why SQL Agent is used?

0 Answers   Abacus,

---

what is normalization? Explain different levels of normalization? : Sql server database administration

0 Answers  

---

What is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure?

0 Answers  

---

What do you understand by physical_only option in dbcc checkdb?

0 Answers  

---

How to set the current database in ms sql server?

0 Answers  

---

how can you select rexcord(rows) from table A which is not present in Table B . Id being the FK in Table B referencing to ID Table A

0 Answers   United Healthcare,

---

which query u can write to sql server doesn't work inbetween 7.00PM to nextday 9.00AM

5 Answers   Wipro,

---

What is a domain constraint give an example?

0 Answers  

---