Answer / Gaurav Garg

A standby server in SQL Server is a secondary server that automatically takes over database operations when the primary server fails or becomes unavailable. It maintains a copy of the transaction logs from the primary server and applies changes to its own database, ensuring minimal downtime during failover.

Explain alternate key, candidate key and composite key in sql server?

1 Answers  

---

How to provide column names in insert statements in ms sql server?

1 Answers  

---

Do you know spatial data types - geometry and geography in sql server 2008?

1 Answers  

---

Differentiate between truncate vs delete in mssql?

1 Answers  

---

In which format does an image save in SQL Server database ?

1 Answers   MCN Solutions,

---

Explain couple pf features of SQL server

2 Answers  

---

How do I start sql server 2016?

1 Answers  

---

When multiple after triggers are attached to sql table, how to control the order of execution?

1 Answers  

---

Explain the ways to controlling cursor behavior?

1 Answers  

---

What does it mean to manipulate data?

1 Answers  

---

What is the difference between primary key and unique constraints?

1 Answers  

---

What are the different types of lock modes in sql server 2000?

1 Answers  

---