Answer Posted / guru

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

Explain what is it unwise to create wide clustered index keys?

947

---

Explain magic tables in sql server?

1014

---

List all types of constraints in sql server?

976

---

What is table join?

1077

---

List out the different types of locks available in sql server?

947

---

How to count rows with the count(*) function in ms sql server?

974

---

What are the advantages of log shipping?

951

---

Tell me what is fill factor?

927

---

what are different types of backups available in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration

901

---

Which language is supported by sql server?

978

---

What is primary key index?

942

---

Explain the concept of view and Types of views in SQL server?

956

---

Do you know hot add cpu in sql server 2008?

921

---

What is public role in sql server?

1102

---

What are views used for?

984

---