What is difference between oltp and olap?

0 Answers  

---

how to change column into row in sql

4 Answers   ESS,

---

what is Covering Index ?

3 Answers   Thomson Reuters,

---

How to insert multiple rows with a subquery?

0 Answers  

---

What are the steps you will take to improve performance of a poor performing query?

1 Answers   HCL,

---

---

Is it important for a database administrator to understand the operating system and file access?

0 Answers  

---

Suppose you want to implement the one-to-one relationships while designing tables. How would you do it?

0 Answers  

---

Please give me the SP for the below scenario. I have two tables named Table1 and Table2...I need to fetch record by record from Table1 and insert the record in to table2 where the value in the sno column of the table1 is even number.

4 Answers   Value Labs,

---

Where views are stored in sql server?

0 Answers  

---

What is check constraint in sql server?

0 Answers  

---

When would you use it?

0 Answers  

---

can you any body tell me the how to decrease the logfile

4 Answers  

---