Answer Posted / ashwini

xp stands for extra power

What is normalization? Explain its different types?

604

---

What is the impact on other user sessions when creating indexes?

542

---

Tell me what is log shipping?

571

---

What is normalization of database?

600

---

Explain about builtinadministrator?

594

---

---

What is difference between delete and truncate commands?

531

---

Do you know concepts and capabilities of sql server?

584

---

How many types of stored procedures are there in sql server?

562

---

Define self join?

629

---

How can I check if a view exists in a sql server database?

567

---

Does partitioning improve performance sql server?

493

---

Explain the difference between primary keys and foreign keys?

511

---

Explain can you implement data mining in ssrs?

106

---

List the different types of joins?

568

---

Explain primary key, foreign key and unique key?

546

---