what is lazy writer?

1 Answers   Wipro,

---

Their are two tables 'A' and'B'.Table 'A' contains 3 columns named 'eid','ename','dept'. Table 'B'contains 3 columns named'sid','designation','salary'. We have to retrieve the names of employees working in the same department,same designation and same salary. Its urgent can anyone help me out in this problem.

6 Answers   Tech Mahindra,

---

What are the advantages of paper records?

0 Answers  

---

What is sql server profiler trace data file?

0 Answers  

---

How do we rollback the table data in SQL Server

3 Answers  

---

---

There is a trigger defined for INSERT operations on a table, in an OLTP system. The trigger is written to instantiate a COM object and pass the newly insterted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better?

1 Answers   HCL,

---

What are security principals used in sql server 2005?

0 Answers  

---

could you please reply for these question: 1.About Use Apply? 2.Avoid cursors - When we have a situation that we can not avoid the use of cursor than what is the alternate solution? is there anything we can use instead of cursor to perform the desired task? which optiomize the peroformance too. 3.What is computed columns? Thanks in advance. Regards, Rupesh

3 Answers  

---

What is a table called, if it has neither cluster nor non-cluster index? What is it used for?

0 Answers  

---

What is the difference between lock, block and deadlock? : sql server database administration

0 Answers  

---

Explain log shipping?

0 Answers  

---

How can delete duplicate records in cte in sql server?

0 Answers  

---