The SQL instance will only be active on any one node at a time. If you have a 16 node cluster you can install 16 instances on it and each one could be active on its own node. You however can't spread the load across multiple physical servers.
SQL Server 2008 R2 will support scaleout across multiple nodes for data warehouses only using the Parallel Data Warehouse Edition, however this requires buying specific hardware, and is something like $2M to get started.
Last Wiki Answer Submitted: April 13, 2010 6:22 pm by Denny Cherry64,505 pts.