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 is dimension table? : sql server analysis services, ssas

0 Answers  

---

Is Sql non procedural query language?

1 Answers   Verifone,

---

what is Archive old data?

1 Answers  

---

What is isolation levels?

0 Answers  

---

What are the different types of replication are there in sql server 2000?

0 Answers  

---

What are statistics?

0 Answers  

---

what is difference between Enterprise Manager and Query Analyer

6 Answers   CTS,

---

What is a function? Give some example?

3 Answers  

---

What are the advantages of using views. Why do we need views when we have SPs?

4 Answers   247Customer,

---

How to determine the service pack currently installed on SQL Server?

4 Answers   HCL,

---

Diff. b/w Full Outer Join And Cross Join?

3 Answers  

---

How can I create a new template for import ? : sql server management studio

0 Answers  

---