Answer Posted / ramakrishna

select e1.* from emp e1 where n=(select
count(distinct(e2.sal)) from emp e2 where e1.sal<=e2.sal);

Does partitioning improve performance?

920

---

What are the different types of replication you can set up in sql server?

985

---

To which devices can a backup be created and where should these devices be located? : sql server management studio

972

---

What is the use of tempdb? What values does it hold?

1003

---

Explain what is log shipping?

1075

---

plss anybody specify tha constrian management system in dbms

2082

---

Explain about system database?

1002

---

How do we upgrade from SQL Server 6.5 to 7.0 and 7.0 to 2000?

1948

---

How to move database physical files in ms sql server?

961

---

What is b tree index?

859

---

Does a server store data?

866

---

Recommend an approach to ensuring that all changes in the remote databases synchronize with the SQL Azure database?

128

---

What is repeatable read?

935

---

How to sort the query output with order by clauses in ms sql server?

984

---

What is side by side migration in sql server?

1023

---