What are the different types of cursor?

0 Answers   HCL,

---

What is Schema? and why we use schemas?

4 Answers  

---

In what version of sql server were synonyms released?

0 Answers  

---

What are sub-queries? Give example? In which case sub-queries are not feasible?

4 Answers   Infosys,

---

How will you monitor replication latency in transactional replication? : sql server replication

0 Answers  

---

---

SQL stops working in every 15 days displaying message that database log file is full. Log file size is 3.95 GB. It is happening after shrinking the database also. What is solution to overcome this problem. Please help me as it's urgent.

5 Answers  

---

How to replace the Query Result 'Null Value' with a text ?

0 Answers   MCN Solutions,

---

What are constraints in microsoft sql server?

0 Answers  

---

Due to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down?

0 Answers  

---

how to delete duplicate rows in sql server2005

7 Answers   Cisco, CTS, HCL, IBM,

---

How to create logins using windows Authentication mode?

2 Answers  

---

1. Tell me your daily activities 2. If sql server installation fails at time installation what will do 3. Where does the sql server installation log details are stored 4. After the installation what will you do for memory configuration 5. What is the difference between SQL max maximum memory and AWE memory 6. How will you configure AWE memory 7. How will setup an email alert for the backup job 8. After the SQL installation what are the jobs will you configure 9. What does –g mean in the sql startup parameter 10. What is the difference between Bulked log and Full recovery model 11. What is the difference between mirroring and log shipping 12. What are the steps to be followed before in-place up gradation 13. After installing the patch the sql server does not start and application team tells to rollback the changes .In this scenario what will you do

0 Answers   CSC, IBM,

---