Answer / brijesh kumar

Index is used for fast retrival data from a table. There are
two types of index
1.clustered Index
2.Non-clustered Index
1. clustered index is created on primary key and it can be
only on per table
2.Non-clustered Index can be created any column and it can
be more than one in a table

Composite key:- Composite is the combination of more than
one attribute composite key is created when it is not
possible to identify any column in a table that has unique
value in such
a situation combination of more than column is chosen by
which
record can be identify easly clear it is just like primary
key.

What are the different types of lock modes in sql server 2000?

0 Answers  

---

What action plan is preferred if sql server is not responding?

0 Answers  

---

what is the difference between Delete and Truncate command in SQL

0 Answers   BirlaSoft,

---

How will you optimize a stored procedure optimization?

0 Answers  

---

What is difference between materialized view and view?

0 Answers  

---

---

What is log ldf?

0 Answers  

---

what is Data Transformation Services (DTS) ?can u explain me in detail?

5 Answers   TCS,

---

What are the differences between user defined functions and stored procedures?

0 Answers  

---

What is a schema in ms sql server 2005?

0 Answers  

---

What is the size of transaction log file?

0 Answers  

---

Does the unique constraint create an index?

0 Answers  

---

What is the use of group by clause?

0 Answers  

---