What is sql server schema compare? How we can compare two database schemas?

0 Answers  

---

What are the benefits of using stored procedures over sql statements?

3 Answers   Ness Technologies,

---

A table contains list of customers and his city with other details. Each customer has a unique number and the table consists millions of data. Query is: I want to retrieve 10 customers from each city, no script, only from single query?

8 Answers   Infosys,

---

Types of Authentications in Sql Server? How user gets authenticated through windows authentication?

0 Answers   MCN Solutions,

---

Explain the steps to use transact-sql cursor?

0 Answers  

---

What is used to replicate sessions between instances in coldfusion clusters?

0 Answers   HCL,

---

How to transfer data from a cursor to variables with a "fetch" statement?

0 Answers  

---

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

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 difference between table and view

1 Answers  

---

List the different types of joins?

0 Answers  

---

what's the difference between delete table and truncate table commands? : Sql server database administration

0 Answers  

---