Answer Posted / krishna

select * from emp e where 2>(select count(esal) from emp
where e.esal<=esal)

How do I view a stored procedure in sql server?

956

---

What is use of attribute hierarchy optimized state? : sql server analysis services, ssas

1023

---

How to delete duplicate records based on single column from a table?

1011

---

How do you start single user mode in clustered installations?

917

---

What are different types of statement?

964

---

How to find index size for each index on table?

975

---

1. Tell me your daily activities 2. If sql server installation fails at time installation what will do 3. Where does the sql server installation log details are stored 4. After the installation what will you do for memory configuration 5. What is the difference between SQL max maximum memory and AWE memory 6. How will you configure AWE memory 7. How will setup an email alert for the backup job 8. After the SQL installation what are the jobs will you configure 9. What does –g mean in the sql startup parameter 10. What is the difference between Bulked log and Full recovery model 11. What is the difference between mirroring and log shipping 12. What are the steps to be followed before in-place up gradation 13. After installing the patch the sql server does not start and application team tells to rollback the changes .In this scenario what will you do

2455

---

How to find the login name linked to a given user name?

963

---

Explain aggregate functions?

1039

---

what is the different types of backups available in sql server? : Sql server database administration

896

---

what changed between the previous version of sql server and the current version? : Sql server database administration

968

---

What happens on checkpoint?

986

---

What methods do you follow to protect from sql injection attack?

981

---

Explain raiserror in sql server?

976

---

Is mysql the same as sql server?

932

---