Answer / saravakumar

You can use index hint (index=index_name) after the table
name. SELECT au_lname FROM authors (index=aunmind)

WHICH INDEX IS FAST CLUSTER AND NON CLUSTER INDEX

4 Answers   CarrizalSoft Technologies, L&T,

---

Tell me what do we need queues in sql service broker?

1 Answers  

---

Can multiple columns be used in sql group by clause in ms sql server?

1 Answers  

---

Is resultset an interface?

1 Answers  

---

What meant by Performance Tuning,how can we do the performance tuning on stored procedures and tell some steps to do the performance tuning

3 Answers   TCS,

---

How to optimize stored procedure optimization?

1 Answers  

---

What is a fill factor?

1 Answers  

---

A trigger can reference objects outside the current database? State true or false.

1 Answers  

---

What is Index Segmentation ?

1 Answers   TCS,

---

If i have one transaction say mainTransaction, within this mainTransaction i have another two transaction say t1 and t2. Now while execution t1 completes successfully and commit statement fires, but while executing t2 some error occurs and rollback statement fires. What happen to t1, is it rollback or not?

1 Answers   Ness Technologies,

---

What is the name of the system variable that returns the number of rows affected by a SQL statement?

1 Answers   HCL,

---

Why do we use trigger?

1 Answers  

---