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 is view in sql?

900

---

What is a field name?

957

---

What are the types of sql server?

1048

---

What is named query? : sql server analysis services, ssas

958

---

Explain the difference between clustered and non-clustered index?

920

---

Difference between 2NF &3NF ?

1084

---

Explain datetimeoffset data type in sal server 2008?

904

---

What do you mean by 'normalization'?

1056

---

Data table as parameter in sql server?

1041

---

What do you understand by the analysis services in sql server?

937

---

Explain nested trigger in sql?

1067

---

how to determine the service pack currently installed on sql server? : Sql server database administration

960

---

What is the native system stored procedure to execute a command against all databases?

1023

---

Explain the architecture of ms sql reporting service?

918

---

what are the steps you will take to improve performance of a poor performing query? : Sql server database administration

936

---