Tell me in brief how sql server enhances scalability of the database system?

0 Answers  

---

What is the process of normalising?

0 Answers  

---

What is one of the first things you would do to increase performance of a query? For example, a boss tells you that ?a query that ran yesterday took 30 seconds, but today it takes 6 minutes?

2 Answers   Accenture, Merrill Lynch, Wipro,

---

How do I find sql server instance name?

0 Answers  

---

Give me any three differences between Truncate and Delete.

0 Answers   Genpact,

---

---

What do you understand by the analysis services in sql server?

0 Answers  

---

please differentiate between delete and truncate?

0 Answers  

---

What are the advantages of stored procedure in sql server?

0 Answers  

---

What is the difference between online clustering and Offline clustering?

0 Answers   IBM,

---

List out a number of the wants to setup a SQL Server failover cluster?

0 Answers  

---

How can your resolve deadlocks?

4 Answers   IBM, IMS, Iron Mountain, NuWare,

---

What happens if you insert a duplicate key for the primary key column in ms sql server?

0 Answers  

---