Answer Posted / b.hari kumar reddy

mainly five type of indexes in sql

1.simple index
2.composite index
3.unique index
4.Clustered index
5.Non-clustered index

What is the difference between Clustered and Non-Clustered Index?

1100

---

What is amo? : sql server analysis services, ssas

1130

---

Explain transaction server implicit?

1023

---

Hi all, can any one please tell me the difference between sql server 2008 and orace 9i

2001

---

How to insert multiple rows with one insert statement in ms sql server?

1173

---

What is the difference between a unique key and primary key?

1001

---

How to find the list of fixed hard drive and free space on server?

1278

---

Define right outer join in sql server joins?

1105

---

How to select true false based on column value in sql server?

1080

---

What is data file in computer?

999

---

Explain “row_number()” in sql server with an example?

1051

---

How you can find out if an index is useful to the optimizer?

985

---

What do you understand by the denormalisation?

1016

---

what are user defined datatypes? : Sql server database administration

1011

---

What is built-in function?

1052

---