Answer Posted / selvaraj.v

In SQL Server 2000 Query:
-------------------------

select max(salary) from Employee where salary not in(select
max(salary) from employee)

This Query only selects the 2'nd Higehest Salary in that
table. So, you will try...

What are page splits? : SQL Server Architecture

938

---

What are synonyms?

914

---

In which files does sql server actually store data?

854

---

How do I view a trc file?

900

---

How will you optimize a stored procedure optimization?

956

---

How to declare a cursor with "declare ... Cursor" in ms sql server?

982

---

What is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting are possible?

954

---

How do I completely remove sql server instance?

1026

---

what types of replication are supported in sql server? : Sql server database administration

960

---

What do you do in data exploration

929

---

How to execute multiple stored procedures at one time in sql server?

945

---

Due to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down?

1266

---

What is the difference between update lock and exclusive lock?

914

---

What is SQL Azure Data sync?

119

---

What are the tool windows in sql server management studio? : sql server management studio

1019

---