Answer Posted / madhuparna

select top 1 * from (select top 2 * from employee)A

Why use update_statistics command in sql server?

558

---

Define the one-to-one relationship while designing tables.

511

---

what are the critical issues you have resloved in your company

1552

---

Can I use sql azure as a backup with log shipping or database mirroring?

136

---

what is a transaction and what are acid properties? : Sql server database administration

527

---

---

how can you attach more than 20 ldf files in sql server

1573

---

Explain unique key in sql server?

540

---

Can we write trigger for view?

558

---

What is a covering index?

536

---

Explain how does the report manager work in ssrs?

501

---

What is the importance of concurrency control?

665

---

What is the difference between stored procedure and functions?

603

---

What is measure group, measure? : sql server analysis services, ssas

552

---

Do you know hot add cpu in sql server 2008?

540

---

Using the customer, and order table in northwind database, please write a query to produce xml?

656

---