Is it important for a database administrator to understand the operating system and file access?

0 Answers  

---

What r sql reporting services and analysis services? how can we use it.

2 Answers   Microsoft,

---

How to check what was the last restore transaction LSN on Log-Shipping and Mirroring when we doesn't have a Monitor server and Witness server?

2 Answers   IBM,

---

How you can move data or databases between servers and databases in sql server?

0 Answers  

---

What is row_number()?

0 Answers  

---

---

What is log shipping? Can we do logshipping with SQL Server 7.0 - Logshipping is a new feature of SQL Server 2000. We should have two SQL Server - Enterprise Editions. From Enterprise Manager we can configure the logshipping. In logshipping the transactional log file from one server is automatically updated into the backup database on the other server. If one server fails, the other server will have the same db and we can use this as the DR (disaster recovery) plan.

0 Answers  

---

What does top operator do?

0 Answers  

---

Write an sql query to sort a table according to the amounts in a row and find the second largest amount.

0 Answers   Amazon,

---

What is the purpose of the master database?

0 Answers  

---

How to return the top 5 rows from a select query in ms sql server?

0 Answers  

---

What are scheduled tasks in sql server?

0 Answers  

---

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

0 Answers  

---