Answer / Ajay Kumar Chaudhary

Stored Procedures, Triggers, and Indexes have several disadvantages:
1. Stored Procedures: They can be difficult to debug and modify since they encapsulate multiple SQL statements.
2. Triggers: Can lead to performance issues due to their execution being triggered by other events and causing cascading effects.
3. Indexes: While beneficial for query performance, they consume additional storage space, take time to create and maintain, and can slow down data modification operations.

Where is trigger in sql server?

1 Answers  

---

Why do you want to join software field as you have done your BE in Electronics?

1 Answers   Cap Gemini, HCL,

---

How ssrs maintain security?

1 Answers  

---

What is a fill factor?

1 Answers  

---

What are filegroups in sql server?

1 Answers  

---

How to create a stored procedure with a statement block in ms sql server?

1 Answers  

---

9. Write a query to list a new column with the difference in temp of the cities Delhi and Mumbai, Mumbai and Jammu and soon. Consider the following table : City_id City Temp. 1 delhi 40 2 Mumbai 35 3 Jammu 32 4 Pune 18

2 Answers  

---

Types of Authentications in Sql Server? How user gets authenticated through windows authentication?

1 Answers   MCN Solutions,

---

What does the not null constraint do?

1 Answers  

---

How optimize sql query with multiple joins in sql server?

1 Answers  

---

What is query processing?

1 Answers  

---

Can you explain different types of joins?

1 Answers  

---