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.

How to integrate the ssrs reports in application?

0 Answers  

---

What does it mean if @@cursor_row returns a negative number?

0 Answers  

---

What are “phantom rows”?

0 Answers  

---

Lets say due to N/W or Security issues client is not able to connect to server or vice versa. How do you troubleshoot?

1 Answers  

---

What is the maximum size of a row in sql server?

0 Answers  

---

Find first and last day of current month in sql server

0 Answers  

---

Is resultset an interface?

0 Answers  

---

When would you use an insert into .. Select option versus an insert into .. Values option? Give an example of each?

0 Answers  

---

how to delete duplicate rows from table in sql server

12 Answers   HCL, UHG,

---

How do SQL server 2000 and XML linked?

2 Answers  

---

how can u select the Distinct values in the table, table having 20 columns , i want all columns

2 Answers  

---

What are the rules to use the rowguidcol property to define a globally unique identifier column?

0 Answers  

---