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.

what are user defined datatypes? : Sql server database administration

922

---

Delete duplicate rows without using rowid.

1489

---

How to create new databases with "create database" statements?

958

---

How except clause is differs from not in clause?

895

---

Why use “pivot” in sql server?

1041

---

Can we perform backup restore operation on tempdb?

953

---

What is difference between table aliases and column aliases? Do they affect performance?

909

---

Can you name a few encryption mechanisms in sql server?

890

---

Tell me what is the stuff and how does it differ from the replace function?

932

---

How will you know when statistics on a table are obsolete?

1031

---

Can you pass expressions to stored procedure parameters?

969

---

When to use null data driven subscription?

196

---

What are cursors in ms sql server?

1109

---

What is the dbcc command and why is it used?

994

---

What is de-normalization and what are some of the examples of it?

922

---