Answer Posted / suresh jp

select emp_no,max(salary) over() from table_employee;

What are some examples of schemas?

535

---

John exports information periodically from a microsoft sql server database to an oracle database what is the best way to do this?

534

---

Explain the difference between primary keys and foreign keys?

515

---

Can a table be moved to different filegroup?

574

---

How to defragment indexes with alter index ... Reorganize?

588

---

---

what’s the difference between Covering Indexes and Clustered Indexes ? how to use clustered index small ?

1579

---

How to rebuild all indexes on a single table?

591

---

How to use union to merge outputs from two queries together in ms sql server?

560

---

What is a raid and what are different types of raid configurations?

632

---

What do you mean by authentication modes in sql server?

611

---

What options are there to delete rows on the publisher and not on the subscriber? : sql server replication

681

---

Is the order of columns in the set clause important in ms sql server?

521

---

What is the default port for SQL Server over a firewall?

593

---

How do I find query history in sql server?

518

---

What are the risks of storing a hibernate-managed object in a cache? How do you overcome the problems?

598

---