Explain the disadvantages of cursors?

0 Answers  

---

why would you use sql agent? : Sql server database administration

0 Answers  

---

What are the differences between left join and inner join in sql server?

0 Answers  

---

What are the High-Availability solutions in SQL Server and differentiate them briefly?

0 Answers  

---

You have a stored procedure, which execute a lengthy batch job. This stored procedure is called from a trigger you do not want to slow the data entry process you do not want trigger to wait for this batch job to finish before it completes itself what you can do to speed up the process?

0 Answers  

---

---

Please explain what is “asynchronous” communication in sql server service broker?

0 Answers  

---

Explain about thread and memory management process of SQL?

0 Answers  

---

1.what is the difference between view and cursor? 2.If we do any change in view will it affect the database,similarly when we do changes in cursor will it affect the databse?with certain example?Thanks

5 Answers  

---

find the 3rd max salary

10 Answers  

---

How to configure odbc dsn with different port numbers?

0 Answers  

---

How the authentication mode can be changed?

0 Answers  

---

Introduction of rollup clause using sum and group by clause?

0 Answers  

---