Answer / Manoj Kumar Kushwaha

For implementing mirroring in SQL Server, changes to the front-end code are typically not required. However, you should ensure that your application can handle automatic failover and reconnection to the new principal server when a failover occurs. This may involve implementing connection string logic that accounts for multiple servers and dynamically switches connections based on the current principal server.

How do you measure the performance of a stored procedure?

3 Answers   Infosys,

---

What is the difference between rank and dense_rank?

1 Answers  

---

Can we call future method from queueable?

1 Answers  

---

What is constraints and its types?

1 Answers  

---

What is checkpoint in sql server?

1 Answers  

---

Do you know what is normalization of database? What are its benefits?

1 Answers  

---

WHY CAN WE CREATE ONLY ONE CLUSTERED INDEX ON A TABLE IN SQL SERVER?

8 Answers  

---

What is a sql join?

1 Answers  

---

What is use of except clause?

1 Answers  

---

select names starts with a,b,c

8 Answers   Scope International,

---

How to disable triggers using "disable trigger"?

1 Answers  

---

What is normalization of database?

1 Answers  

---