Answer Posted / suhail qaiser

select top 2 salary from emp order by salary desc

What are different types of data sources?

648

---

what is the difference between count(*) and count(1) ?

811

---

List layers of abstraction microsoft architectured to provide relational db through cloud platform ?

175

---

Can you leave a union at any time?

764

---

Explain about extended stored procedure?

677

---

---

tell me what are the steps you will take to improve performance of a poor performing query? : Sql server database administration

751

---

Explain intellisense for query editing

756

---

what is a check constraint?

845

---

What are subqueries in sql server?

792

---

What is log shipping? Can we do logshipping with SQL Server 7.0 ?

750

---

What happens if null values are involved in comparison operations?

715

---

Can you explain the disadvantages/limitation of the cursor?

674

---

Where views are stored in sql server?

723

---

Do you know what is a linked server in sql server?

714

---

How can you check the version of sql server?

775

---