Answer Posted / jeff jordan

1) Clustered Index
2) Non-Clustered Index

I'm assuming by "which one is best" we mean which has the
faster look ups. This would be the clustered index since it
is the physical ordering of the rows and the non-clustered
index is like a lookup table. With the clustered index one
you've found the index you've found your row...

Differentiate between a primary key and a unique key.

1022

---

What will be the maximum number of indexes per table?

926

---

What are the 7 disadvantages to a manual system?

929

---

How do you make a trace?

972

---

What do you mean by a Composite primary key?

1045

---

How to create nested stored procedure?

976

---

I have triggers,views,functions,stored Procedures for a table. When I am dropping that table which objects are deleted?

1098

---

What are the acid properties?

966

---

Can you explain about buffer cash and log cache in sql server?

915

---

Can you name some of the dml commands in sql?

982

---

How to retrieve error messages using odbc_errormsg()?

1008

---

Does partitioning improve performance sql server?

918

---

How dts is used to extract, transform and consolidate data?

1039

---

What is read uncmmited?

1021

---

Where are stored procedures in sql server?

1025

---