Answer / Tarush Yadav

"Enhanced Database Mirroring" is a high-availability feature introduced in SQL Server 2008 to provide fast and reliable data protection. It improves upon traditional database mirroring by allowing the principal server and mirror server to be on different subnets, using TCP or named pipes for communication, and supporting automatic failover. Additionally, it provides more flexibility in configuring the witness server and allows for automatic page repair on the mirror server.

Can a synonym name of a table be used instead of a table name in a select statement?

1 Answers  

---

What is a data source file?

1 Answers  

---

What is query and its types?

1 Answers  

---

How do you check the performance of a query and how do you optimize it?

1 Answers  

---

Define inner join? Explain with an example?

1 Answers  

---

What do you understand by intent locks?

1 Answers  

---

Can you explain the role of each service?

1 Answers  

---

Explain difference between control flow and data flow?

1 Answers  

---

Can we linked SharePoint to a SQL database?

1 Answers   Sans Pareil IT Services,

---

Differences between functions and stored procedures?

8 Answers   247Customer, Accenture,

---

What is difference between index and primary key?

1 Answers  

---

What is the difference between local table and global table

1 Answers   CarrizalSoft Technologies, Polaris,

---