What is split brain scenario in DB mirroring?

1 Answers  

---

What the different topologies in which replication can be configured?

0 Answers  

---

What keyword you will use to get schema appended to the result set of a ‘for xml’ query?

0 Answers  

---

Mention the differences between local and global temporary tables.

0 Answers  

---

1. How to fetch all the duplicate records from the table. 2. How to fetch the second highest salary from the table.

12 Answers   Accenture,

---

What is lock escalation? : sql server database administration

0 Answers  

---

What is normalization and what are the different forms of normalizations?

2 Answers  

---

Explain Different types of Projects?

1 Answers  

---

Restore database SQL2000, SQL2012 Backup of base is created in Microsoft SQL Server 2000 - 8.00.2066, I can't restore on Microsoft SQL Server 2012 - 11.0.2100.60

3 Answers   IT Decisions,

---

how to control the amount of free space in your index pages? : Sql server database administration

0 Answers  

---

what is the output for this query select * from employee where 1=1;

4 Answers  

---

write the query for taking database restore in sql?

2 Answers  

---