Answer / Shivangi Rastogi

SQL Server 2008 and 2008 R2 introduced several improvements to clustering compared to SQL Server 2005. Here are some key differences:

1. Network protocols: In SQL Server 2005, only TCP/IP network protocol was supported for cluster communications. Starting from SQL Server 2008, other protocols like Named Pipes and NetBIOS over TCP/IP can also be used for cluster communications.
2. Cluster resource types: SQL Server 2008 introduced a new resource type called 'SQL Server Application Resource' which allows you to manage multiple SQL Server instances as a single entity within the failover cluster. This feature is not available in SQL Server 2005.
3. Cluster Shared Volumes (CSV): CSV was first introduced in Windows Server 2008 and is supported by SQL Server 2008 and later versions. CSV allows for better I/O performance and scalability when using cluster shared disks to store data.
4. Failover Cluster Manager: The Failover Cluster Manager in SQL Server 2008 has a new user interface that provides more detailed information about the health of the cluster resources, as well as improved management capabilities.

how can u get last observation in an unknown dataset ?

1 Answers   Genpact,

---

What is the disadvantage of using subquery exact after a select statement?ex. select (select * from sometable)

1 Answers  

---

How to insert multiple rows with a subquery?

1 Answers  

---

Why Master database is required?

1 Answers   Abacus,

---

Explain about Views?

1 Answers   Infosys,

---

What is a join in sql?

1 Answers  

---

Well sometimes sp_reanmedb may not work you know because if some one is using the db it will not accept this command so what do you think you can do in such cases?

2 Answers  

---

Explain contrast amongst grouped and non-bunched records?

1 Answers  

---

What happens if null values are involved in bitwise operations?

1 Answers  

---

How to add a new dsn with the odbc driver for sql server?

1 Answers  

---

Does sql server 2000 clustering support load balancing?

1 Answers  

---

Explain what are the different index configurations a table can have?

1 Answers  

---