What is a data collection table?

0 Answers  

---

What are the risks of storing a hibernate-managed object in a cache? How do you overcome the problems?

0 Answers  

---

What is filter index?

0 Answers  

---

What is cte (common table expression)?

0 Answers  

---

how do you determine the Load performance of any query in sql server {example how do u determine performance of a select stmnt which returns Dynamically many no of records ... some times 100,1000,10000 etc., }

0 Answers   HCL, Wipro,

---

---

What are Magic Table?

34 Answers   3i Infotech, Digiweb, Evalueserve, NIIT, PL,

---

Find top Nth employee from each department in terms of salary?

13 Answers   RealPage,

---

You want to be sure that queries in a database always execute at the maximum possible speed. To achieve this goal you have created various indexes on tables which other statement will keep the database in good condition?

0 Answers  

---

What should be the fill factor for indexes created on tables? : sql server database administration

0 Answers  

---

What is the difference between varchar and varchar types?

0 Answers  

---

How do I shrink an ldf file?

0 Answers  

---

What is a unique index?

0 Answers  

---