Answer Posted / pavan

lot of differences:
1. mirroring
2. transactional with updatable subscription
3. resource database
4. serialization

Explain what is the main purpose of having conversation group?

524

---

Define right outer join?

544

---

Is sql server difficult to learn?

519

---

What is the beast way to write CTE in SQL Server ?

557

---

What is the need for group functions in sql?

567

---

---

What is the recovery model? List the types of recovery model available in sql server?

486

---

What is mscorsvw.exe - process - microsoft .net framework ngen?

526

---

How to apply cascading referential integrity in place of triggers?

568

---

What do you understand by physical_only option in dbcc checkdb?

579

---

How to write a query with a full outer join in ms sql server?

558

---

What are audit control procedures?

584

---

What are the essential components of sql server service broker?

561

---

Can a cursor be updated? If yes, how you can protect which columns are updated?

519

---

What are sql dirty pages?

556

---

Explain how to maintain a fill factor in existing indexes?

528

---