Answer Posted / amruta dash

select max(salary) from tblname where salary not in (select
max(salary) from tblname);

Explain data warehousing in sql server?

1054

---

Explain what are the basic functions for master, msdb, model, tempdb databases?

984

---

What are the differences between lost updates and uncommitted dependencies?

1086

---

What are the different Authentication modes in SQL Server and how can you change authentication mode?

1091

---

Write an SQL query to obtain the 2nd highest salary.

1082

---

Do you know hot add cpu in sql server 2008?

961

---

What is a derived table?

935

---

What is filtered index?

1103

---

Tell me what is sql profiler?

1037

---

How can we rewrite sub-queries into simple select statements or with joins?

984

---

While migrating Microsoft SQL Server 2008 database to SQL Azure, what can be done to ensure the database connectivity does not degrade?

111

---

what is nonclustered index

963

---

How to create a user name in a database?

1060

---

Tell me what are the essential components of sql server service broker?

943

---

What command is used to rename the database?

1018

---