Answer Posted / guru

select max(salary) from Employee where salary not in(select
top (n-1) salary from Employee order by salary desc)

Explain different types of BACKUPs avaialabe in SQL Server? Given a particular scenario, how would you go about choosing a backup plan?

1088

---

What is difference between standardization and normalization?

1160

---

Explain what is the difference between a local and a global temporary table?

1048

---

What is change data capture (cdc) feature?

1124

---

How many types of relations are there between dimension and measure group? : sql server analysis services, ssas

1250

---

What are the differences between decimal and float in ms sql server?

1351

---

sql database suspect We have a sql database that is showing as suspect. How can we recover?

2004

---

Write a query to include a constraint, to check whether the employee salary is greater than 5000?

1659

---

after migrating the dts packg to ssis by using migrtn wizrd in 2005. iam not able to open ssis pack and getting error. what r those errors? how to resolve?

2141

---

What is reportserver and reportservertempdb ?

160

---

What does top operator do?

1081

---

What does asynchronous call backs means?

1236

---

Does sql server use t sql?

1071

---

create index myindex on mytable(mycolumn) what type of index will get created after executing the above statement? : Sql server database administration

1010

---

What are the types of containers in ssis?

1235

---