Answer / sajjan singh

Indexes are data structures that help SQL Server to find
particular rows of data fastly.

In a database, an index allows the database program to find
data in a table without scanning the entire table.
An index in a database is a list of values in a table with
the storage locations of rows in the table that contain each
value.
Indexes can be created on either a single column or a
combination of columns in a table and are implemented in the
form of B-trees.

Clustered Index: "A clustered index is a special type of
index that reorders the way records in the table are
physically stored.
Therefore table can have only one clustered index. The leaf
nodes of a clustered index contain the data pages."

Non Clustered Index: "A nonclustered index is a special type
of index in which the logical order of the index does not
match the physical stored order of the rows on disk.
The leaf nodes of a nonclustered index does not consist of
the data pages. Instead, the leaf nodes contain index rows."

Answer / dinesh rathod

Index is a one important concept in .Net. So you should know the basic idea about index in .Net.

What command would you use to create an index?

0 Answers  

---

Why do you want to join software field as you have done your BE in Electronics?

0 Answers   Cap Gemini, HCL,

---

What is a data collection table?

0 Answers  

---

Hi All, I want to display all duplicate records in the table. My query has to fetch all the records which are duplicate(First Name or Last Name). Also I want the ability to also pull names where there might be a middle initial placed in the end of the first name field, (i.e., "Maria Z. " vs. "Maria") as well. Please guide me to find this. Table: ID FirstName LastName 1 Zach H Hoffman 2 Zach Hoffman 3 Troy Hoffman 4 Shawn Livermore 5 Prem S 6 Jony Hoffman H 7 Zach Modan I need the query to filter......... ID FirstName LastName 1 Zach H Hoffman 2 Zach Hoffman 3 Troy Hoffman 6 Jony Hoffman H 7 Zach Modan I hope this example will give you clear idea..... Thanks in Advance Prem

2 Answers  

---

Write the SQL query to drop, truncate and delete table.

0 Answers   HPCL, Hughes Systique Corporation, Ittiam Systems,

---

How to get the query of a table in sql server?

0 Answers  

---

find the 3rd max salary

10 Answers  

---

How send email from database?.

3 Answers   CarrizalSoft Technologies, Merrill Lynch,

---

How to create indexed view?

0 Answers  

---

Advantages and Disadvantages of Cursor?

15 Answers   Polytechnic, TCS, Zenith,

---

How to delete multiple rows with one delete statement in ms sql server?

0 Answers  

---

Explain different types of locks in sql server.

0 Answers  

---