Which data type columns are the best candidates for full-text indexing?

0 Answers  

---

How global temporary tables are represented and its scope?

0 Answers  

---

What are the properties of the relational tables?

0 Answers  

---

What is an indexed view?

0 Answers  

---

What are subqueries in sql server?

0 Answers  

---

---

How to recover from sql injection? : sql server security

0 Answers  

---

what is the cursor life span?

5 Answers   Evalueserve, HG,

---

Why should we go for stored procedures? Why not direct queries?

0 Answers  

---

Suppose i have one sql query that contains 2 minute to execute.After one weekly i am executing same query that is taking 5 minute.Why our same query is taking more time.what would be my approach to reduce execution time.Please help.

1 Answers   Cognizant, HCL, Value Labs,

---

How important do you consider cursors or while loops for a transactional database?

0 Answers  

---

1.what is the difference between view and cursor? 2.If we do any change in view will it affect the database,similarly when we do changes in cursor will it affect the databse?with certain example?Thanks

5 Answers  

---

What is RAID? What are the different types of RAID configurations?

0 Answers   Flextronics,

---