Answer Posted / sureshsamatham

There can be 1 or more indexes in a table.Indexes can be
clustered or non clustered. A clustered index stores data
rows in the table based on their key values. Each table can
have only one clustered index as the key values in the data
rows are unique and the index is built on the unique key
column. Non-Clustered indexes have structures that are
different from the data rows. A non clustered index key
value is used to point to data rows that contain the key
value. This value is known as row locator. The structure of
the row locator is determined on the basis of the type of
storage of the data pages. If the data page is stored as a
heap, a row locator becomes a pointer to a row. If the data
page is stored in a clustered table the row locator is a
clustered index key. Clustered and Non clustered indexes can
be unique and indexes are automatically maintained for a
table or view whenever the data table is modified.

Can you move the resources after pausing the node? : sql server database administration

1108

---

What is outer join in sql server joins?

1124

---

What is history table in sql server?

973

---

You are doing log shipping due to some reasons it is failing. How you will proceed from there

2072

---

Define self join?

1035

---

What is difference between clustered index and non clustered index?

1079

---

Which are new data types introduced in sql server 2008?

1053

---

What is a mutating table error and how can you get around it?

1051

---

How to find out what is the default collation in a database?

1123

---

How to list all user names in a database?

1058

---

How to recover from sql injection? : sql server security

1023

---

Explain datetimeoffset data type in sal server 2008?

914

---

How to drop existing views from a database in ms sql server?

1103

---

What is sql language?

1150

---

Retrieve the unique rows from table without using UNIQUE and DISTINCT keywords.

1012

---