Do you know what is difference between stored procedure and user defined function?

0 Answers  

---

What's new in sql management studio for sql server? : sql server management studio

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  

---

Can you explain what are various ways to enhance the ssrs report?

0 Answers  

---

What do you understand by the analysis services in sql server?

0 Answers  

---

---

How do I start sql server 2017?

0 Answers  

---

What is one of the first things you would do to increase performance of a query? For example, a boss tells you that ?a query that ran yesterday took 30 seconds, but today it takes 6 minutes?

2 Answers   Accenture, Merrill Lynch, Wipro,

---

What is the difference between a "where" clause and a "having" clause?

0 Answers  

---

List the ways in which dynamic sql can be executed?

0 Answers  

---

Which sql server table is used to hold the stored procedure script?

0 Answers  

---

What are xml indexes?

0 Answers  

---

What is difference between cte and view?

0 Answers  

---