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 Extended user-defined?

0 Answers  

---

What is the downside of using udf?

0 Answers  

---

What is the syntax to execute the sys.dm_db_missing_index_details? : sql server database administration

0 Answers  

---

What is the purpose of a table?

0 Answers  

---

what is a join? : Sql server database administration

0 Answers  

---

What are three ways you can use an identity value inside a trigger? Why would you prefer one way over another?

0 Answers  

---

Do you know hot add cpu in sql server 2008?

0 Answers  

---

Write a program using SQL queries to find a unique entry in a table.

0 Answers   Tech Mahindra,

---

What is one of the first things you would do to increase performance of a query? For example, a boss tells you that ?a query that ran yesterday took 30 seconds, but today it takes 6 minutes?

2 Answers   Accenture, Merrill Lynch, Wipro,

---

Do you know what are the restrictions applicable while creating views? : SQL Server Architecture

0 Answers  

---

What is isnull() operator?

0 Answers  

---

What is clustered index

0 Answers  

---