Answer Posted / kumar_kisna

select max(salary) from table where salary<(select max
(salary) from table)

What is the impact on other user sessions when creating indexes?

535

---

What are the recovery models in sql server 2000?

546

---

How you trouble shoot when any job fails

1498

---

How to display a past time in days, hours and minutes?

561

---

Explain powershell included in sql server 2008?

598

---

---

What happens if you are trying to access a schema not owned by you?

502

---

What is the purpose of sql profiler in sql server?

504

---

Do you know what is sql service broker?

524

---

Tell me something about security and sql azure?

100

---

Write query to return all rows sql?

604

---

Explain the etl (extraction, transformation, and loading)?

549

---

How to verify the port number of the sql server?

545

---

What does it mean to normalize data?

508

---

What is data modification?

502

---

What is difference between equi join and natural join?

530

---