What are statistics, under what circumstances they go out of date, how do you update them?

2 Answers   HCL,

---

What are the new features in SQL Server 2005 when compared to SQL Server 2000?

0 Answers  

---

Can you explain what are various ways to enhance the ssrs report?

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 is the command dbcc checkdb used for?

0 Answers  

---

---

How to Update from select query in sql server?

0 Answers  

---

from the table display the 2nd highest salary? and also the least 2nd salay?

8 Answers  

---

Is port 1433 secure?

0 Answers  

---

In the primary key have a multiple field or not?

8 Answers   TCS,

---

What is the purpose of update statistics and scope_identity() function?

0 Answers  

---

What is scheduled job and how to create it?

0 Answers  

---

Explain following error properties?

0 Answers  

---