Answer Posted / balu

I Agree with the point one but not agreed with the next one

"its uses mainly Load balancing and Fault tolerance."

It is not like all the tier 3 system will use the above.

Loadbalancing and fault tolerance will increase the
availablility and scalablity of the System

What are different type of Collation Sensitivity?

1012

---

What is report snapshot in ssrs?

276

---

What is the maximum size of sql server database?

1022

---

What is pessimistic concurrency?

983

---

How to access the deleted record of an event?

1042

---

Does partitioning help performance?

945

---

What you can do to delete a table without the delete trigger firing?

980

---

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

926

---

What is a dbms wizard?

1028

---

What is the difference between a fill factor of 100 and 0?

995

---

How to see the event list of an existing trigger using sys.trigger_events?

1081

---

How would you go about developing a ssrs report?

174

---

Explain features of analysis services?

1014

---

What authentication modes does sql server support?

1110

---

Explain table valued parameters in sql server? Why tvp used?

1032

---