How do you trace the traffic hitting a sql server?

0 Answers  

---

What are different types of table joins?

0 Answers  

---

Can we execute a stored procedure inside a trigger?

6 Answers   BirlaSoft, CarrizalSoft Technologies, United Healthcare,

---

Can two tables have the same primary key?

0 Answers  

---

Write a sql query to display the current date?

0 Answers  

---

---

Explain transaction server auto commit?

0 Answers  

---

What is SubQuery in SQL Server 2008

0 Answers   HCL,

---

sql server has its default date format in da form "yy-mm-dd" its possible to convert da current date format of sql server to desired format. Now my question is dat how to get da previous and comin days date in my desired format??

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,

---

What is a primary index?

0 Answers  

---

Describe the functionalities that views support.

0 Answers  

---

Can we add a cpu to sql server?

0 Answers  

---