Answer Posted / yoursguna@gmail.com

SELECT * FROM `salary_table` group by `salary` order by
`salary` desc limit 1,1

What is cube dimension? : sql server analysis services, ssas

1017

---

Explain rdbms?

1047

---

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

1082

---

What do you mean by an execution plan? Why is it used?

1037

---

Why union all is faster than union?

921

---

What is replication with database mirroring? : sql server database administration

1084

---

What is a performance monitor?

980

---

How will you add a dimension to cube? : sql server analysis services, ssas

1095

---

How to perform key word search in tables?

966

---

What are points to remember while using the fillfactor argument?

976

---

Please explain what is “asynchronous” communication in sql server service broker?

944

---

What are the rules to use the rowguidcol property to define a globally unique identifier column?

1026

---

What are synonyms?

967

---

Is sql different from sql server?

1098

---

Explain the difference between clustered and non-clustered index?

932

---