Answer Posted / ravi

select top 2 from tablename

What are the steps you will take to improve the performance of a poor performing query?

597

---

How are the exceptions handled in sql server programming?

611

---

what is a mixed extent? : Sql server administration

607

---

what is denormalization and when would you go for it? : Sql server database administration

707

---

Explain timestamp datatype?

552

---

---

Why use “pivot” in sql server?

629

---

Explain collation?

622

---

What is Extended user-defined?

535

---

Explain syntax for dropping triggers?

522

---

What is an expensive query?

538

---

What is a trace frag? Where do we use it?

673

---

Can you explain about buffer cash and log cache in sql server?

505

---

What is relationship? What number of sorts of relationship are there?

639

---

What is Dependency Injection and provide example?

616

---

What specific conditions database should meet, before you can bulk copy data into it using bcp?

536

---