Answer Posted / prakash

Cluster index :-

1) CLUSTERED INDEX IS PHYSICALLY STORED THE DATA.

2)ONE TABLE CAN HAVE ONLY ONE CLUSTERED INDEX
BECAUSE IT STORED IN ORDER OF THE CLUSTERED KEY.

3)CREATING A CLUSTERED INDEX ON A TABLE RE-ARRANGES
THE DATA IN A SEQUENTIAL MANNER

4)ONCE WE DEFINED A COLUMN WITH PRIMARY KEY CONSTRAINT, SQL
SERVER AUTOMATICALLY CREATES UNIQUE CLUSTERED INDEX ON THAT
COLUMN




5) THE LEAF LEVEL OF A CLUSTERED INDEX IS THE ACTUAL
DATA


__________________________________________________________
NON-CLUSTERED INDEX:-

1)NON- CLUSTERED INDEX IS LOGICALLY STORED DATA.

2) ONE TABLE CAN HAVE 249 NON- CLUTTERED INDEX IN SERVER-2005
AND 999 IN SERVER-2008

3)NON-CLUSTERED INDEX IS CREATED ON A TABLE, THE DATA IS NOT
PHYSICALLY
RE-ARRANGED IN SEQUENTIAL ORDER.


4)ONCE WE DEFINED A COLUMN WITH UNIQUE KEY CONSTRAIN , SQL
SERVER AUTOMATICALLY CREATE NON CLUSTERED INDEX.

5) NON-CLUSTERED INDEX THE LEAF LEVEL IS
ACTUALLY A POINTER TO THE DATA IN ROWS

What does ss stand for sexually?

1009

---

What are entities and relationships?

921

---

What are constraints?

958

---

What is the downside of using udf?

1043

---

What does top operator do?

963

---

what purpose does the model database serve? : Sql server database administration

921

---

How to use order by with union operators in ms sql server?

967

---

What is a raid and what are different types of raid configurations?

1203

---

How to modify existing triggers using "alter trigger"?

934

---

What are the instances when triggers are appropriate?

926

---

New concepts of sql server 2005 use in your project.

2303

---

What is a non clustered primary key?

874

---

Do you know what is lock escalation?

963

---

What is the syntax to execute the sys.dm_db_missing_index_details?

966

---

What programming language would you use to create embedded functions in ssrs?

172

---