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 faster join or union?

1102

---

What is read uncmmited?

1010

---

How do I connect to sql server database?

947

---

Which are new data types introduced in sql server 2008?

987

---

What is rs.exe utility?

150

---

Why use triggers?

965

---

Why do we use stored procedures in sql server?

893

---

Once setting replication, can you have distributor on sql server 2005, publisher of sql server 2008?

902

---

How do I make a resultset scrollable?

908

---

Can group functions be used in the order by clause in ms sql server?

960

---

Can you explain what is the use of custom fields in report?

999

---

How to perform backup for certificates in sql server? : sql server security

1023

---

What is linked report?

118

---

What does it mean to normalize data?

894

---

What is unique key constraint?

987

---