Answer Posted / guru

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

Is it ok to shrink transaction log?

939

---

can you instantiate a com object by using t-sql? : Sql server database administration

963

---

List the different index configurations possible for a table?

884

---

How raid can influence database performance?

974

---

What is raid and what are different types of raid levels?

1079

---

What is the current limitation of the size of SQL Azure DB?

124

---

Explain multiserver query

964

---

Explain the categories of stored procedure i.e. System stored procedure, local stored procedure, temporary stored procedure, extended stored procedure, remote stored procedure?

986

---

Relational calculus is what type of language?

978

---

How and why use sql server?

955

---

In how many ways you can invoke ssrs reports?

132

---

Does a server store data?

866

---

What does it mean to manipulate data?

944

---

How to create a view and a stored procedure in ms sql server using "create view/procedure" statements?

932

---

What is a heap?

985

---