Answer Posted / ravikiran

select * from employee.e1 where (n-1) =
( select (distinct b.salary ) from employee.e2 where e1.salary > e2.salary

How to use order by with union operators in ms sql server?

1024

---

When is the use of update_statistics command?

1009

---

Do you know what are different types of replication in sql server?

1099

---

What are .mdf files?

942

---

How do you start single user mode in clustered installations?

942

---

What is policy based management (pbm)? : sql server database administration

989

---

you want to be sure that queries in a database always execute at the maximum possible speed. To achieve this goal you have created various indexes on tables which other statement will keep the database in good condition? : Sql server administration

1082

---

What is the preferred way to create a clustered and non-clustered index? Which index should you create first the clustered or non-clustered?

914

---

How to drop an existing stored procedure in ms sql server?

1032

---

Where are SQL server users names and passwords are stored in sql server?

1273

---

To automatically record the time on which the data was modified in a table, which data type should you choose for the column?

964

---

Explain Geometry datatype in sql server 2008 with example

992

---

Data table as parameter in sql server?

1050

---

Mention the differences between substr and charindex in sql server.

1051

---

What is nonclustered index with included columns ?

968

---