Has anyone implemented SQL Server 2005 Enterprise Edition running on Windows 2003 Compute Cluster server? If so, I would very interested in hearing about both positive and negative aspects of the combination and more importantly, the lessons learned.
Reason for this information is due to a fairly large system I managed, which is over 2TB in size and growing rapidly, primarily DSS intensive, but also has an OLTP element (e.g. loading large external datasets). The main crunch is during computations, which we may be able to improve with a distributed processor architecture.