Answer / Sonia Verma

Using User Defined Functions (UDFs) can have several drawbacks. UDFs can negatively impact query performance due to their execution overhead and the potential need for temporary tables. Additionally, UDFs may not be able to leverage indexes or statistics as effectively as built-in functions. Lastly, parameter sniffing issues can arise when using UDFs in parameterized queries.

What is SQL Profiler what is the use of it?

2 Answers   247Customer, Steria,

---

What is mssql?

1 Answers  

---

Tell me about Triggers?

3 Answers   Cap Gemini,

---

What is simple indexing method?

1 Answers  

---

There is table like Events...in that name ,startdate ,enddate,location are the column names write a stored Procedure for this table to get events by Months "GetEventsByMonths"

2 Answers  

---

What is a trigger what are the advantages of trigger?

1 Answers  

---

What is the difference between 2-Tier architecture and 3-Tier architecture

15 Answers   CTS, MCN Solutions, Oracle,

---

Why use triggers?

1 Answers  

---

What guidelines should be followed to help minimize deadlocks?

1 Answers  

---

How do you fine the performance tunning?

2 Answers   Accenture,

---

What is a dbms wizard?

1 Answers  

---

What is create command?

1 Answers  

---